| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel return the earliest date from a list?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can Excel return the earliest date from a list?
Dates are simply numbers, so to get the earliest date, just use the Min
function. Regards, Fred. "joeb" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can Excel return the earliest date from a list?
If you have a set of dates in row #1, the earliest date is the smallest date.
In cell IV1 enter: =MIN(A1:IU1) -- Gary''s Student - gsnu200781 "joeb" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you find the earliest date when using an IF function? | Excel Worksheet Functions | |||
| Earliest date using WEEKNUMBER | Excel Worksheet Functions | |||
| How do I find the earliest date? | Excel Discussion (Misc queries) | |||
| extracting earliest date (age) from list | Excel Discussion (Misc queries) | |||
| Earliest Date to populate? | Excel Worksheet Functions | |||
Linear Mode
