=WEEKDAY(DATE(YEAR(B$3),MONTH(B$3),DAY($A4)),3)

Apply the above to each cell in the matrix and then set conditional
formatting to cells where cell value is =5; as a weekend

Note: Excel will allow invalid date e.g. 31 Apr by computing the day as 1
May - the correct day number is returned.

--
Cheers
Nigel



"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
is this possible in my scenario?

this is a date table
column headings for each month, b3 has 1/1/2006, using eomonth function
for
the rest of the months and headings formatted MMM .

in column A, i just have integers, 1 through 31.

is it possible to format cells based on weekends?

i have done it for individual months on separate sheets, but don't know if
this is possible with this set up.

--


Gary