=>Select 31 columns and wanted rows => Paste Formula below with Ctrl +Enter
=DATE(YEAR(B4),MONTH(B4),1)+{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31}-1
B4 is the source of month, example: January-2014. You can change to any month as you want.
Result:
There are formatting in the table. For example, Saturday and Sunday. Please do as below
=>Select whole month => Conditional Formatting => New Rules => See below formula
=WEEKDAY(DATE(YEAR($B$6),MONTH($B$6),DAY(B$6)),2)>5
This is very important trick. B6 is the first day of the month. Please use ($) only one in DAY.
