Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Master Calendar

Hi,

I need to set my End Date as always Current YearEnd Example for this year (2021/12/31). How to achieve this automatically.

Here is my current Calendar

 

1 Reply

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee

    You can use

    DATE(YEAR(TODAY()), 12,31)

     

    Regards,

    Pat