Can Excel return the earliest date from a list?

J

joeb

I have a list of dates (Date in stock) for three different warehouses across
a row. Is there a formula that can determine the earliest date in stock and
return it at the end of the row?
 
F

Fred Smith

Dates are simply numbers, so to get the earliest date, just use the Min
function.

Regards,
Fred.
 
G

Gary''s Student

If you have a set of dates in row #1, the earliest date is the smallest date.
In cell IV1 enter:

=MIN(A1:IU1)
 
Top