Out of month

=MONTH(DATE(YEAR($B$1),MONTH($B$1),B2))<MONTH($B$ 1)

--
HTH

Bob Phillips

"Jagruti" wrote in message
...
Hi,
Need some help for the captioned subject.
I am entering a date on the top cell of col B

Then there are numbers from 1 to 31 from cell B5 downwards.
These numbers represent the day of the month.

I want to highlight the cells that are having sundays with
one colour and those out of month with another colour.

Is it possible?
Thanks,
Jagruti.