This equation below works - but when I try to substitute b7 for 39083 it
doesn't

=OR((DATE(2007,1,1)={39083,39097,39132,39267,39328 ,39356,39397,39408,39441}))

What do I have to do to the above equation to allow cell references - rather
than hardcoding the dates (in the list)?

I will want to check every day of the year against the list of numbers -
presented above

"Brad" wrote:

I have created a calendar that will shade out the weekends. I would like it
to have a different shade (for holiday's) - with possibly an "H" in the cell.

In the cells for the other workday's I will be leaving blank - or putting in
the number of hours - I'm taking off -- this last piece I have working as
well.

Any suggestions on how to automate the shading (with the possibility of an
"H" in the appropriate days cell(s))