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.