In A2, I have input 1/1/2014 and custom formatted it as "mmmm" to show month name. Then Select the range B5:AF39 and use the following formula for conditional formatting....
See the attached sheet.![]()
=OR(TEXT(WEEKDAY(DATE($AG$2,MONTH($A$2),B$4)),"aaa")="Fri",TEXT(WEEKDAY(DATE($AG$2,MONTH($A$2),B$4)),"aaa")="Sat")
Is this what you are trying to achieve?
Bookmarks