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 it in the new calculated column. Would anyone be bale to advise what formula would work for this?

 

Thanks,

 

Edd

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