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
Solved! Go to Solution.
@jdevalk ,
from today
Calendar(today(), eomonth(today(),3) )
or from month start
Calendar(eomonth(today(),-1)+1 , eomonth(today(),3)
Great, many thanks!
@jdevalk ,
from today
Calendar(today(), eomonth(today(),3) )
or from month start
Calendar(eomonth(today(),-1)+1 , eomonth(today(),3)
User | Count |
---|---|
183 | |
81 | |
74 | |
74 | |
47 |
User | Count |
---|---|
165 | |
91 | |
89 | |
79 | |
74 |