Odd Schedule in excel

Occasional Visitor

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.  

0 Replies