Need a formula to compare month and year

[Emanuel Levy]

I looked at http://www.excelguru.ca/content.php?...standing-Dates and can't figure out how to check if the date in a cell is equal to the current month and year. I know how to see if this moth is greater than or equal to a month in another cell but that doesn't work if the date in the other cell is from a prior yer,

[Kevin@Radstock]

Hi Emanuel Levy
How about if you put it in a AND function.
=AND(MONTH(A1)=MONTH(TODAY()),YEAR(A1)=YEAR(TODAY()))

[Bob Phillips]

Try


=TEXT(A2,"mmyyyy")=TEXT(TODAY(),"mmyyyy")