View Single Post
  #4   Report Post  
Old May 16th 06, 09:36 AM posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default 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.:

=MAX(IF(Code=M1,Dates,0))

This could go into cell O1, committed with CTRL-SHIFT-ENTER again, and
copied down.

Hope this helps.

Pete