Evaluate three dates, return the greater date 3

[FYRGUY47]

Greetings,

In Excel 2002, I need to evaluate three dates in three seperate cells, A1, B1, C1 formatted as mm/dd/yy, and have the greater of the three dates displayed in the forth cell "D1"
Any help would be very much appriciated.

Chris

 

[FYRGUY47]

Macropod,

Thanks for the idea and input. I will work on it again next week when I go back to work. Thanks again..

Chris

 

[FYRGUY47]

Okay,

Finaly got back to the form today. By changing the =0 to ="" in the earlier formula, that took care of the 01/00/00 result I was getting. This is the formula that works fine now.

=IF(AND('09May12'!G25="",'09May12'!F29="",'09May12'!F35=""),"", MAX('09May12'!G25,'09May12'!F29,'09May12'!F35))

Many Thanks to Skip, & GS for your patients & help on this one. Also thanks to Macropod for your input.

Chris

 

[FYRGUY47]

Also thanks to TonyJollans!!

Chris