Hi Emanuel Levy
How about if you put it in a AND function.
=AND(MONTH(A1)=MONTH(TODAY()),YEAR(A1)=YEAR(TODAY()))
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,
Hi Emanuel Levy
How about if you put it in a AND function.
=AND(MONTH(A1)=MONTH(TODAY()),YEAR(A1)=YEAR(TODAY()))
Try
=TEXT(A2,"mmyyyy")=TEXT(TODAY(),"mmyyyy")
Bookmarks