Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Datetable next 3 months

Hi all,
I would like to create a new datetable with only next 3 months which I will use for forecasting figures.

So something like MONTH(TODAY()+1) and +2 and +3 but I have no idea how to do so.

Anyone?

BR,

Jurgen

  • Anonymous ,

    from today

    Calendar(today(), eomonth(today(),3) )

     

    or from month start

    Calendar(eomonth(today(),-1)+1 , eomonth(today(),3)

2 Replies

  • Anonymous ,

    from today

    Calendar(today(), eomonth(today(),3) )

     

    or from month start

    Calendar(eomonth(today(),-1)+1 , eomonth(today(),3)

  • Anonymous's avatar
    Anonymous
    Not applicable

    Great, many thanks!