Date/Calender formula

[Kristensen11]

Hi,

I am trying to make a formula that take a certain period of time (M-1, M0, M1, M2, M3 and M4) So the previous month and 5 month ahead.

I made a similar code for the past 6 month: =if((Dim_Calendar[Date]>=DATE(YEAR(EOMONTH(TODAY();18*-12));MONTH(EOMONTH(TODAY();18*-12));1))*(Dim_Calendar[Date]<DATE(YEAR(EOMONTH(TODAY();-12));MONTH(EOMONTH(TODAY();-12));1));"Yes";"No")

And i tried doing something similar for the 5 month forward: =if((Dim_Calendar[Date]>=DATE(YEAR(EOMONTH(TODAY();-1));MONTH(EOMONTH(TODAY();-1));1))*(Dim_Calendar[Date]<DATE(YEAR(EOMONTH(TODAY();+5));MONTH(EOMONTH(TODAY();+5));1));"Yes";"No")

However, i only get 2 M-1 and M0.

Can someone please help me?

Br,

 

[steve the fish]

You want month plus 1, month plus 2? Try:

=EDATE(TODAY(),1)