Flagging all dates next month

[stuwannop]

H All

I currently have a master calendar where I can calculate various flags on the dates based Financial Year to date, dates to month end etc etc. For example this formula gives me all dates in this month:

IF(InMonthtoDate(Date,MonthEnd(today()),0),1,0)

What I am trying to do now is flag all the dates NEXT month, so at the time of this post (July) all dates in August 2013 will be flagged.

Can anyone help?

Thanks in advance

Stu

[tresesco]

Something like this?

If( Month(Addmonths(Today(),1)) =Month(Date), 1, 0) as Flag

[stuwannop]

Thanks Tresesco it's almost there but it's returning all August dates regardless of the year and I only need 2013. I've tried a few other things but I can't get it to work at the mo.

Stu

[tresesco · Accepted solution]

So try :

If( Month(Addmonths(Today(),1)) =Month(Date)   AND Year(Today())= Year(Date), 1, 0) as Flag

[stuwannop]

Marvellous - I was almost there but that works perfectly - thanks very much for your help.

Stu