I have 2 columns with dates in it, what's the formula for a third column to show most recent date?

manzier

Board Regular
Joined
Jul 21, 2014
Messages
96
Hi all,

As title says, what would be the formula to list out the most recent date between the dates in the Date1 and Date2 columns?

Date1Date2Most Current
3/1/20134/9/2014=?
5/2/20145/9/2014=?
10/1/2014=?
11/1/2014=?

<tbody>
</tbody>

Thanks!
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,109,320
Messages
5,527,996
Members
409,798
Latest member
Snake68

This Week's Hot Topics

Top