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???