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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top