right formula to include it in conditional format when I need to include many criterias

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....

=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")

See the attached sheet.

Is this what you are trying to achieve?