G
Guest
Hi everyone. Simple question...how would I correct my formula such that if
the date in C8 is a certain date (regardless of the year!), then... The
formula I tried is: =IF(C8=AND(MONTH(10),DAY(26)),"text") where
C8=TODAY(). When I click on the AND in the wizard it says both statements
are TRUE but if I click before the AND, it says FALSE.
Alternatively, I also tried: =IF(TODAY()=AND(MONTH(10),DAY(26)),"text").
However in the wizard, the result is "Volatile" and the cell displays FALSE.
the date in C8 is a certain date (regardless of the year!), then... The
formula I tried is: =IF(C8=AND(MONTH(10),DAY(26)),"text") where
C8=TODAY(). When I click on the AND in the wizard it says both statements
are TRUE but if I click before the AND, it says FALSE.
Alternatively, I also tried: =IF(TODAY()=AND(MONTH(10),DAY(26)),"text").
However in the wizard, the result is "Volatile" and the cell displays FALSE.