Need a formula to compare month and year

Kevin@Radstock

New member
Joined
Oct 5, 2012
Messages
52
Reaction score
0
Points
0
Excel Version(s)
365
Hi Emanuel Levy
How about if you put it in a AND function.
=AND(MONTH(A1)=MONTH(TODAY()),YEAR(A1)=YEAR(TODAY()))
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Try


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