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.