Forum Discussion

Edd_Keogh's avatar
Edd_Keogh
Copper Contributor
Oct 31, 2022
Solved

Most Recent Date

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 i...
Lists
  • NicolasKheirallah's avatar
    NicolasKheirallah
    Oct 31, 2022

    Edd_Keogh 

     

    A nested If-statement will solve this:

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

     

NicolasKheirallah's avatar
NicolasKheirallah
MVP
Oct 31, 2022

Edd_Keogh 

 

A nested If-statement will solve this:

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

 

Resources