I created a spreadsheet. I want to have tabs for each month. I want to be able to enter the year in my January tab. I would like to be able to enter the year and month in their respective places and have the days of the month and the weekday automatically populated. I have been emulating another spreadsheet I have found online and can get all of this done manually but I want the date and weekdays to automatically populate. I would like the be able to change the year and have the days and weekdays automatically change. The first file (time tracing new) is what I have done manually the second one is the one which I am trying to emulate.

Attached Files

	TimeTracingNew.xlsx (37.2 KB, 12 views)
	2015-Employee-Attendance-Tracking-Calendar.xlsx (89.3 KB, 13 views)