If you want to check only months, try this,
=MONTH(cell reference)=8

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Free addins Office Menu-2003 for Office-2007)
If You Can't Excel with Talent, Triumph with Effort.


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