How do I get the most recent date to another cell

mterrell1979

New Member
Joined
Sep 23, 2006
Messages
1
I am a new user of Excel and it is not playing very nice with me. In my spreadsheet, I have a row of dates. I want to transfer the most recent date from that row to another cell automatically. Is this possible. Please help me, I am lost.
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Doug.T

Board Regular
Joined
Sep 19, 2006
Messages
80
If you have a row of dates in cells A2 to X2 then the formula =max(a2:x2) will get you the most recent date.
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
If you want to ensure you only return dates that are before today's date then you can use:

=MAX(IF(A1:A10<=TODAY(),A1:A10))

confirmed with Ctrl+Shift+Enter. If this has worked, Excel will surround the formula with curly braces {}.

Best regards

Richard
 

Watch MrExcel Video

Forum statistics

Threads
1,109,197
Messages
5,527,376
Members
409,759
Latest member
KCH

This Week's Hot Topics

Top