Thread: [Solved] If with multiple And
View Single Post
 
Old 10-23-2020, 12:46 AM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
I think you were just over keen on your brackets

This seems to work


=IF(AND(MONTH($D6)=MONTH(TODAY()),DAY($D6)=DAY(TOD AY())),"��","")
Reply With Quote