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.

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.

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.

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.

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.