How do I find the earliest dates in a range of dates?
Dates are stored internally in Excel as the number of days since a
reference date (1st Jan 1900), so really they are just integers.
Today's date is effectively 38853. Hence 40000 is much larger than
this, and so will never be included as the minimum. If you wanted the
latest date you would use MAX and replace the 40000 with 0, i.e.:
This could go into cell O1, committed with CTRL-SHIFT-ENTER again, and
Hope this helps.