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, 10 views)
	2015-Employee-Attendance-Tracking-Calendar.xlsx (89.3 KB, 11 views)

In order to extract the day there is a function in Excel called DAY. So if we go to the function wizard, go to the DATE and TIME category you will see that there is a DAY function, and we say OK. All it asks is tell me where the serial number is or the date. We will just point it and say OK.