Work Schedule

See big yellow banner - how to upload a workbook - easier then for us to work with an in-context example.

Not sure what the numbers in cells D2:Y26 are supposed to represent.
I don't believe that 20 people (4 teams of 5 associates) can cover 22 Stations.
That said, perhaps this will be a starter:
1. Make a list of days of the week and teams in columns AJ:AK
2. Populate AB1:AE1 using: =TEXT(TODAY(),"dddd") and =AB1
3. Populate AB2:AE26 using: =IF(OR(WEEKDAY(TODAY(),2)>=6,INDEX($AK$2:$AK$6,MATCH(AB$1,$AJ$2:$AJ$6,0))=$C2),"",INDEX($D$1:$Y$1,MOD(SUM(COLUMNS($AB2:AB2),COUNTIFS(AB$1:AB1,"Sta*"))-1,COUNTA($D$1:$Y$1))+1))

Does the proposed solution in post #4 do what you want?

Hello,
This may be more than what I can ask for, but I'll give it and try and hope for the best. I need a schedule built that will allow me to rotate individuals through a weekly schedule. I have attached a spreadsheet that has instructions as to what is required. Here are the parameters for the schedule which are also on the attachment:

− Five Teams
− 6 Team Members per team
− Five day work week
− Ten Hour Schedule
− Four teams work daily with one team off each day
- There are eighteen Stations that are rotated throughout the shift
− Each team has one day off per week
− One 40 Minute Lunch
− Two 10 Minute Breaks
− Team rotates every two hours
− Tasks one and two rotate
− Task 2 Only Requires Two Team Members Per Day, the other three Go Back Into Rotation with Task 1.
− Need to allow substitutions for absences in Task 1 Only

Thank-you in advance for any help with this effort!