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)

 

[BGY23]

Hi,

Try if(Month(Now()=Month(AM2),True,False)

 

[nielf]

Hi,

Try if(Month(Now()=Month(AM2),True,False)

I tried the formula but I still get his error:

 

[BGY23]

My Bad,

=If(Month(Now())=Month(AM2),True,False) I missed a 2nd ) after Now

 

[ukmikeb]

This will suffice :-

=MONTH(NOW())=MONTH(AM2)

to give the required result.

hth

 

[nielf]

We're almost there now.

The only thing is that the formula doesn't take the current year into account. It shows TRUE for all dates which are in May no matter what year.

 

[Rick Rothstein]

We're almost there now.

The only thing is that the formula doesn't take the current year into account. It shows TRUE for all dates which are in May no matter what year.

Give this formula a try...

=TEXT(A1,"mmmyyyy")=TEXT(NOW(),"mmmyyyy")

 

[nielf]

Give this formula a try...

=TEXT(A1,"mmmyyyy")=TEXT(NOW(),"mmmyyyy")

The issue seems to be the same with all the formulas. The month is correct but it is not limited to the current year (2015). I might not have been clear on that.

=TEXT(A1,"mmmyyyy")=TEXT(NOW(),"mmmyyyy"

=MONTH(NOW())=MONTH(AM2)

=If(Month(Now())=Month(AM2),True,False)

I have uploaded a spreadsheet with all the formulas here.

 

[BGY23]

Your bad
You didn't mention year in your OP so I didn't take it into account.

=IF(AND(MONTH(NOW())=MONTH($Am$2),YEAR(NOW())=YEAR($AM$2)),True,False)

<COLGROUP><COL style="WIDTH: 374pt; mso-width-source: userset; mso-width-alt: 18249" width=499><TBODY>
</TBODY>

 

[JackDanIce]

What is the value in AM2? What is the cell number formatting of AM2?

It may help using specific values and examples to get the correct answer; otherwise Rick's answer should work, as should:

=AND(MONTH(NOW())=MONTH($AM$2),YEAR(NOW())=YEAR($AM$2))