▲ 3 r/excel
Making a dynamic calendar in Excel
I'm trying to create a dynamic calendar in Excel for my work. We run 4 crews running either days or nights. I'm just wanting to make it to where I can change the year and it automatically changes the schedule for the year. Also when Crew A is working days, Crew D is working nights. Crew B follows Crew A. And Crew C works the opposite from Crew B. For example, Crew A is on Days. That means Crew D is on Nights. When Crew A starts their days off, Crew B is working Days and Crew C is working Nights. I have included what I already do, but it is very time consuming to make them. I was just wanting something where I can change the year and it's already done.
Thank you for any help!
u/Far-Salary9838 — 5 days ago