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))
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
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 worked the day by day:

 

 

I tried to have the first day per month only, but I got this error:

 

 

Can you guide me?


Thanks!