Thread: Can Excel return the earliest date from a list?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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 With QuoteReply With Quote