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
|