Can Excel return the earliest date from a list?

  • Thread starter Thread starter joeb
  • Start date Start date
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?
 
Dates are simply numbers, so to get the earliest date, just use the Min
function.

Regards,
Fred.
 
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

Similar Threads

HELP! Need to have earliest test record data 2
Return earliest date 3
How do I find the earliest date? 1
How to invert column entries in Excel 1
SUMIF Criteria 5
Chinese tombs yield earliest evidence of cannabis use 0
How to find earliest record based on unique identifier from a list ofdata 4
Earliest and latest dates that can be correctly represented in Exc 2

Back
Top