Hi All,
I have been using the "shift work" template in excel to create a rolling yearly calendar. I have edited one to have each month with days/dates and this automatically updates based on the year I select. I was hoping to create another sheet within the workbook which again is a rolling yearly calendar, but instead of individual days/dates per month, it has "weeks commencing" with Mondays being the day the week commences on. Is there a way to do this, and can it automatically change based on year selected? I have copied pictures below to help explain what I am trying to achieve.
Many Thanks
I have been using the "shift work" template in excel to create a rolling yearly calendar. I have edited one to have each month with days/dates and this automatically updates based on the year I select. I was hoping to create another sheet within the workbook which again is a rolling yearly calendar, but instead of individual days/dates per month, it has "weeks commencing" with Mondays being the day the week commences on. Is there a way to do this, and can it automatically change based on year selected? I have copied pictures below to help explain what I am trying to achieve.
Many Thanks
