Moved to: https://github.com/PeterGeelen/TechNetGallery/tree/master/Excel%20Year%20calender%20with%20weekend%20markers

 

Template excel sheet, using conditional layout to automatically mark weekend 

Tips of use:you can change the year in the first upperleft field.

The Excel sheet will automatically format the weekends with grey markers and the workdays will be set blank.

 

Conditional formatting based on weekday count (using formula to set start week at Monday)

Weekday number 6+7 = sat + sun

=WEEKDAY($G3;2)>=6