Saturday Work Schedule - 28 Advisors - 8 Shifts

Hello Excel Guru’s

Looking for some help with creating a schedule for Saturdays

I have 28 team members
There are 8 shifts to randomize .

Shift # 1 – 10:00 – 5:00
Shift # 2 – 10:00 – 5:00
Shift # 3 – 11:00 – 6:00
Shift # 4 – 11:00 – 6:00
Shift # 5 – 11:00 – 6:00
Shift # 6 – 12:00 – 7:00
Shift # 7 – 12:00 – 7:00
Shift # 8 – 12:00 – 7:00



Each Team member needs to go through the schedule pattern and repeat when they get to the end as needed to finish out the 52 weeks.
However on each Saturday each of the 8 shifts need to be present.

Like to have
Distribute the 8 shifts evenly as possible over 28 Team Members for the 52 Saturdays

While trying to limit as much as possible
• Multiple Saturdays in the same month
• No back to back Saturday shift

Let me know if you have any questions

I have added a template to work with

Thanks in advance

Have a look at my attached.

I don't see why you would want to complicate things by randomising the shifts, just stagger the shifts over the period, so eventually everyone should work each shift. Then randomise who gets allocated to which Advisor Position. The number of Advisors means that all the shifts are covered evenly for 7 weeks, so you could randmoise the Advisor to staff member each 7 weeks so there are chances of each person working with a different person each 7 week cycle.

Thank You Both

kersplash - Agree do not want to over complicated it - I originally has a version of your suggestion but the piece of the puzzle I was missing to make it work was the staggering the starting point every 7 weeks. Once I saw that it all clicked and made the most sense.

FlameRetired - Looking at your suggestion closer, unfortunately in the end as you work down the list of advisors and you do a count of what shifts they worked after 52 weeks - There ends up being advisors that don't work a shift at all.

Once again Thank You both for your time and your excel knowledge.