Hi RS,

You were very close,

=IF(AND(MONTH(C8)=10,DAY(C8)=26),"text")


HTH

Simon

RS wrote:
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.

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200610/1