View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Find Earliest Date

=min(a2,b2)

Regards,
Fred.

"Elaine" wrote in message
...
Hello,

I have 2 dates, not in any order. I would like to create a formula to give
me the earliest date of the 2.

Example:

A B C
1 Date1 Date2 Result/Answer
2 4/20/08 1/20/08 1/20/08
3 2/28/08 5/10/08 2/28/08
4 5/7/08 2/14/08 2/14/08

I thank you in advanced for your continued support.
--
Respectfully... Elaine