Earliest Date to populate?
 

Anyone,

I'm trying to gather a bunch of dates in an Excel spreadsheet row and have
the earlies date by itself just populate in a cell. Does anyone have a sample
formula to use?

It's racking my brain and driving me nuts!

Thanks!

=MIN(A1:Z1)

Biff

"sonquizzon" wrote in message
...
Anyone,

I'm trying to gather a bunch of dates in an Excel spreadsheet row and have
the earlies date by itself just populate in a cell. Does anyone have a
sample
formula to use?

It's racking my brain and driving me nuts!

Thanks!

Have you tried:
=MIN(A1:A10)

Just replace A1:A10 with your actual range of dates.
You might have to format the result as a date (otherwise you'll get a number
in the 38 thousand range)

Does that help?
--
Regards,
Ron