Forum Discussion
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.
I am trying to get something like this, which the day is always the 1st of each month:
If we were 2022-3-5 for example, then the calendar should reflect March 2021 to February 2022, and so on.
How could I have a rolling 12M calendar?
Appreciate the help commnity.
Hi,
Try this Table formula
Calendar = CALENDAR(edate(EOMONTH(today(),-1)+1,-12),EOMONTH(today(),-1))
8 Replies
Hi,
A Calendar table should always have a row for each day from the first to the last day. So getting only the first day of each month is a bad idea, even if it is possible to do so. To get a rolling 12 month calendar, you may try this Table formula
=calendar(edate(startofmonth(today()),-12),startofmonth(today())-1)
I have not tried this but am hoping that it will work.
First of all thanks for your support.
I tried the formula but the following error came up:
How can I get it ok?
And also, taking your advise, how would a 12M rolling calendar would look like with a row for each day from the first to the last day?
Thanks!
Hi,
Try this Table formula
Calendar = CALENDAR(edate(EOMONTH(today(),-1)+1,-12),EOMONTH(today(),-1))
