How to Find a Date in Excel
- 1). Copy and paste the following formula to find the maximum date into the spreadsheet:
=MAX(B1:B10)
If you want to find a minimum date, change "MAX" to "MIN." - 2). Change B1:B10 to match the location of the dates where you want to find the minimum or maximum dates. This particular string is looking for a date somewhere between cell B1 and B10.
- 3). Press the "Enter" key. Excel will return the maximum date.