=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.