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,

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.

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

    Hi Ashish_Mathur 

     

    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!

    • 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!