Select the most recent date
 

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.

Select the most recent date
 

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

=LARGE(A1:C100,1)

Format cell as DATE

will give latest ("largest") date

"dbs" wrote:

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.

Select the most recent date
 

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


--
Regards,

Peo Sjoblom



"dbs" wrote in message
...
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.

Select the most recent date
 

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

--
Regards,

Sebation.G
"dbs" ...
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.

Select the most recent date
 

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


--
Don Guillett
SalesAid Software

"dbs" wrote in message
...
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.