Formula If Date Falls into Current Month

[squeakums]

I'm trying to write a formula (if date falls into current month)

This one isn't working:

=IF(AY3=MONTH(TODAY()),"Yes","No") It just creates No for everyone even those with dates that fall into the current month/year.

The field I'm viewing also has a formula into it - Ay3 does.. to pull dates.

 

[DaveBlakeMAAT]

try

=IF(MONTH(AY3)=MONTH(TODAY()),"Yes","No")

 

[squeakums]

It looks like its flagging those in 2014 too in September, Can it be written to use the Current Month/Year?

 

[DaveBlakeMAAT]

=IF(AND(MONTH(AY3)=MONTH(TODAY()),YEAR(AY3)=YEAR(TODAY())),"Yes","No")

 

[squeakums]

That works, thank you so much Do you know how to also write it - for another column to say if it is due the following month (due next month)?

 

[DaveBlakeMAAT]

It would be something like this:

=IF(AND(MONTH(AY3)-1=MONTH(TODAY()),YEAR(AY3)=YEAR(TODAY())),"Yes","No")

Basically you calculate the month and subtract 1 then compare that it is equal to the current month.

 

[DaveBlakeMAAT]

Sorry this would be slightly more robust as it will still work if the current month is december (next month is Jan)

=IF(AND(MONTH(EOMONTH(AY3,-1))-1=MONTH(TODAY()),YEAR(EOMONTH(AY3,-1))=YEAR(TODAY())),"Yes","No")

 

[Joe4]

=IF(AND(MONTH(AY3)=MONTH(TODAY()),YEAR(AY3)=YEAR(TODAY())),"Yes","No")

Here is another alternative that is a little shorter:

=IF(TEXT(AY3,"mmyyyy")=TEXT(TODAY(),"mmyyyy"),"Yes","No")

For the one month difference once, I would just incorporate the EDATE function into the formula above:
https://www.techonthenet.com/excel/formulas/edate.php