Try...

=AND(TEXT(A1,"mmmm")="August",YEAR(A1)=2007)

or

=AND(MONTH(A1)=8,YEAR(A1)=2007)

Rick


"FC" wrote in message
...
Thanks for the formula. Bob Phillips you missed a parentesis in the first
formula, but I figured out. Thanks. Do you have one that will include the
month and the year too ?
Thank you also Shah Shailesh
"Bob Phillips" wrote:

=TEXT(A1,"mmmm")="August")

or

=MONTH(A1)=8

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"FC" wrote in message
...
I have columns with hundreds of dates.
I need a Conditional Formatting formula to text color all dates, let's
say
in August.
I know how is done, just need the FORMULA, if somebody is so kind.
Appreciatte it. Thanks.