find most recent date in a row

[Marge]

I have columns similar to these (the dates represent project completion dates):

A B C
blue team OK red team OK white team OK
4/5/09 5/7/09 6/27/09

In column D I want to enter the most recent of the A, B and C dates. If the
dates were in columns instead of rows I could filter for the most
recent....how can I "filter" across a row?

Thanks for any help you can offer!

 

[Jacob Skaria]

=MAX(A2:C2)
and format cell to date

If this post helps click Yes

 

[Marge]

Great! And if A, B and C are all blank, how can I tell D to be blank also?

 

[Jacob Skaria]

=IF(COUNT(A2:C2)=0,"",MAX(A2:C2))

If this post helps click Yes

 

[Marge]

You're the King! Thanks so much for your help!

=IF(COUNT(A2:C2)=0,"",MAX(A2:C2))

If this post helps click Yes