Formula for Most Recent Date

D

DGS

I have a document that has multiple dates in a row. I want to write a
formula that recognizes most current date in each row and then puts the most
recent date in a cell on another tab on the same spreadsheet. Any help is
appreciated.

Thanks
 
J

John C

e.g.:
You have dates in columns A thru F, rows 1-100, on Sheet1
G1: =MAX($A1:$F1), copy down
on other sheet
A1: =MAX(Sheet1!$G$1:$G$100)

Ensure column G and cell A1 are formatted as dates. That will give the most
'recent' date, assuming you do not have dates in the future.
 
Top