Hi!

Try this:

=OR(MONTH(C2)=MONTH(TODAY()),MONTH(TODAY())-1=MONTH(C2))

Biff

"viddom" wrote in message
...
I have a column with the birthday of some clients and I want the cell
format
to change to yellow when his date of birth is withing the current and the
next monat. In order to do that I wrote these formula in the first and
second field of the conditional formating panel=C2=MONTH(TODAY()) and
=C2=MONTH(TODAY())+1 , but it doesn't work.

Can't you tell me what am I doing wrong

Thanks