Formula issue for Current/Previous month Date

[hecgroups]

Hello Again,

Formula below will return yes if the date falls in current months.

I need help to amend the formula for previous 1 months.

For Example: if the date falls in between months of February and March 2014 then return yes.

In short I need to a formula which return yes if the date falls in current or previous months.

Formula:

Please Login or Register  to view this content.

[:) Sixthsense :)]

Try this...

=IF(AND(OR(MONTH(TODAY())=MONTH(CM2),(MONTH(TODAY())-1)=MONTH(CM2)),YEAR(TODAY())=YEAR(CM2)),"Yes","-")

[hecgroups]

Thanks it is working as I hope topic marked as solved and reputation is added.

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback and rep