If date is current month - true/false

[nielf]

Hi,

I'm trying to use an IF formula to return true of false if the date in AM2 is the current month.

I have found a formula that works for the current day:

=IF(TODAY()=INT(AM2);TRUE;FALSE))

However, I can figure out how to get it working for the current month. I have tried this but the formula contains too many arguments.

=IF(MONTH(TODAY()=INT(AM2);TRUE;FALSE)

 

[nielf]

I'm sorry I forgot to mention that.

I works. Thank you very much for the help. It is very much appreciated.

 

[BGY23]

You're welcome, have a good weekend