Oh, ok, I see what you mean:

1/31/2006
2/1/2006

Well, the posted example didn't "demonstrate" that that is how this is to be
used. <g

Biff

"Biff" wrote in message
...
How?

MOD(30,2)=0
MOD(31,2)=1

Biff

"CaptainQuattro"
<CaptainQuattro.27xv42_1147847423.0779@excelforu m-nospam.com wrote in
message
news:CaptainQuattro.27xv42_1147847423.0779@excelfo rum-nospam.com...

If you use Mod(day... you will get two adjacent same-coloured rows at
the end of a month with 31 days.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile:
http://www.excelforum.com/member.php...o&userid=32763
View this thread:
http://www.excelforum.com/showthread...hreadid=542781