View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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?