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.