Most Recent Date

[Edd_Keogh]

Good morning all,

I have quite a large list with a lot of columns I want to add a calculated column that looks at date 1, date 2, and date three, it then takes the most recent date and displays it in the new calculated column. Would anyone be bale to advise what formula would work for this?

Thanks,

Edd

[#2 · Accepted solution]

@Edd_Keogh 

A nested If-statement will solve this:

=IF([DATE1] > [DATE2], IF([DATE1] >[DATE3],[DATE1],[DATE3]),IF([DATE2] > [DATE3],[DATE2],[DATE3]))