How do I find the earliest date?
 

I have a column of dates that range anywhere from 10/1/2006 to the current
day. I know I can put a filter on that column and the list will show me the
earliest date in the drop down, but I'd like to skip that step and have the
earliest date from the list of dates appear automatically in another cell.
Any suggestions???

How do I find the earliest date?
 

Use

=MIN(Date_Range)

format as date if you get a large serial number


--
Regards,

Peo Sjoblom



"Dave Shultz" wrote in message
...
I have a column of dates that range anywhere from 10/1/2006 to the current
day. I know I can put a filter on that column and the list will show me
the
earliest date in the drop down, but I'd like to skip that step and have
the
earliest date from the list of dates appear automatically in another cell.
Any suggestions???