I am over scheduling and we have our guys broke down into a 4 days on, 4 days off shift rotation. We have 2 day shifts and 2 nights shifts that work in rotation. How would I create a schedule in excel that would auto populate for the year. I want to know who will be scheduled to work on a random date in the future to help with scheduling of time off.
