Thread: formula to look up and return smallest date from a range of dates
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default formula to look up and return smallest date from a range of dates
BJ

Excel stores dates as a number starting with 1 at Jan 1, 1900 so I guess that
would be the "smallest date" you could get.

With column A being dates, enter this formula in any cell in an adjacent
column.

=MIN(A:A) and Format as date.


Gord Dibben Excel MVP

On Wed, 7 Dec 2005 13:56:04 -0800, "BJ" wrote:

I need a formula that will look up the smallest date, and return it, from a
range of mixed dates.
Reply With QuoteReply With Quote