To find the dates for minimums and maximums in Excel, you will need to use the MIN and MAX formulas. These formulas will return the minimum and maximum values from a range of cells, respectively. You can use these formulas to find the dates for minimums and maximums in Excel by using the following steps:
Note: If there are multiple cells with the same minimum or maximum value, only one of those cells will be returned by the MIN or MAX formula. The specific cell that is returned is determined by Excel's internal sorting algorithm, which is generally based on cell address (i.e., which cell appears first when sorted left-to-right and top-to-bottom).