Dear smw226,

Sorry for the delay but this was the first chance I got to look at
these solutions. Thanks for your correction to my formula, it now works!
It's nice to see that I was on the right track. With the guidance of people
such as you and Ron in this forum, I am learning to look for help here rather
than waste hours trying to solve an incorrect formula...and in this process,
I'm increasing my Excel knowledge! Thanks to everyone!


"smw226 via OfficeKB.com" wrote:

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