Most Recent Date

Occasional Contributor

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?





1 Reply
best response confirmed by Edd_Keogh (Occasional Contributor)



A nested If-statement will solve this:

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