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

[manzier]

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?

Date1	Date2	Most Current
3/1/2013	4/9/2014	=?
5/2/2014	5/9/2014	=?
10/1/2014		=?
11/1/2014		=?

<tbody>
</tbody>

Thanks!

 

[VoG]

Try

=MAX(A2,B2)

Format as Date.

 

[manzier]

Thanks!