Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Calendar Tables - Dynamic rolling 12M

Hi all   I´d like to have a dynamic calendar which contains the last rolling 12 months.    For example today is 2022-2-20. Therefore the calendar should go from February 2021 to January 2022.   ...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Try this Table formula

    Calendar = CALENDAR(edate(EOMONTH(today(),-1)+1,-12),EOMONTH(today(),-1))
o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
4 years ago

Hi Ashish_Mathur 

 

It's ok. Your code solved my problem, I will stick to your recommendation of full calendar instead.

 

Thank you!!

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

You are welcome.