•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
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!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#real-time data collaboration
#real-time collaboration
#dynamic calendar
#Excel
#crews
#scheduling
#year
#days
#nights
#Crew A
#Crew B
#Crew C
#Crew D
#work schedule