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

Dates are numbers so you can use this function
=SMALL(A1:A100,1)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"BJ" wrote in message ...
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