Select Highest Date

[MattB]

I have 3 dates in 3 cells. Ie. 06/12/2001 cell H3, 24/11/01 in cell I3 and 06/01/01 in J3.
Is it possible to select the latest date of the 3 - I wish to show this in G3. Any ideas?
Many thanks

 

[Mudface]

If you have three different dates in each row, the following seems to work OK: -

=TEXT(MAX(H3:J3), "dd/mm/yyyy") &" "&ADDRESS(ROW(),MATCH(MAX(H3:J3),H3:J3,0)+COLUMN(),4)

Autofill down for each of the rows you have data in.

 

[MattB]

Thank you all VERY much!