Select the most recent date

[Guest]

I have an Excel file in which three columns contain dates. I would like a
function to select which date is the most recent. Any help you could provide
would be much appreciated. Thank you.

 

[Guest]

If dates are in Columns A to C (100 rows):

=LARGE(A1:C100,1)

Format cell as DATE

will give latest ("largest") date

 

[Peo Sjoblom]

Try

=INDEX(Date_Range,MATCH(MAX(Date_Range),Date_Range,0))

if you mean the latest date entry regardless of the date but entered like

date1
date2
and so on

=LOOKUP(99^99,Date_Range)

this assumes that your data are "real" Excel dates that is numerical

 

[Sebation.G]

Try the array formula

=INDEX(A1:A3,MATCH(SMALL(ABS(A1:A3)-NOW(),1),ABS(A1:A3)-NOW(),0),1)

Hope this can be helpful

 

[Don Guillett]

Sub findmax()'chg date format to conform
x = Format(Application.Max(Columns("k:m")), "d-mmm")
Columns("k:m").Find(x, LookAt:=xlWhole, LookIn:=xlValues).Activate
End Sub