SOLVED

Most Recent Date

Copper 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?

 

Thanks,

 

Edd

1 Reply
best response confirmed by Edd_Keogh (Copper Contributor)
Solution

@Edd_Keogh 

 

A nested If-statement will solve this:

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

 

1 best response

Accepted Solutions
best response confirmed by Edd_Keogh (Copper Contributor)
Solution

@Edd_Keogh 

 

A nested If-statement will solve this:

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

 

View solution in original post