Excel day date month year Function
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.
|