Weekend Work Schedule

[gorram]

Hi everyone. I am attempting to create a rotating weekend work schedule in Excel to make life easier. There are 30 people who rotate Saturday's and Sunday's every month. Technically, they are only supposed to work 2 weekends a month, and am attempting a way to create this in Excel to make it more fair to the group instead of just picking and choosing which weekend these employees work, I would like an Excel program to do this for me. Is that possible? I have tried everything.

[David A Coop]

I suggest you post a sample of what your roster would look like using the Attachn=ment paperclip on Go Advanced. That way it is easier to help. Rosters can me very complex beasts or quite simple, so seeing yours will make it easier.

Basically, the easiest approach would be to rotate the staff names, leaving the roster itself fixed. This, every week/fortnight/4 weeks when you prepare the roster, just click the macro button which will move the name(s) from the top of the list to the bottom, giving the next name(s) the weekend row(s).