Need a formula to compare month and year

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")
 
Back
Top