Hi working in transport. I have given myself a task to recreate rota for drivers some of my driver are working every other week 6 days (Monday to Saturday) Sunday off

Rest of them are working every 5 weeks Saturday with rest during the week some of them Tuesday, Wednesday or Thursday.

Question is how to create a rule for it in excel if for every tab I have month assign to it to populate the rule.

In perfect world I would have a rule in separate TAB to print off work schedule for each driver.

​Hi working in transport. I have given myself a task to recreate rota for drivers some of my driver are working every other week 6 days (Monday to Saturday) Sunday offRest of them are working every 5 weeks Saturday with rest during the week some of them Tuesday, Wednesday or Thursday.Question is how to create a rule for it in excel if for every tab I have month assign to it to populate the rule.In perfect world I would have a rule in separate TAB to print off work schedule for each driver.  Read More

​