Find Earliest Date
=MIN(A2:B2)
Copy down as needed.
--
Biff
Microsoft Excel MVP
"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
|