You are going to run into problems when you try your solution, because you'll have to manually delete people from the calendar when they swap days off. Additionally with your somewhat complicated RDO pattern it becomes really complicated.

Look at the attached calendar.

It's an alternative that who is working on any shift (green), who is not working (black) and who is on RDO (blue). I have assumed half the staff is on shift A and the other half is on shift B (and ignored ranks).

If I understood you correctly you (ought to) work in the following pattern (ignoring the monthly extra RDOs): 6 days on - 1 day off - 5 days on - 2 days off - Repeat.

Let's say Bob needs to take 05-Jan off. He can then swap with Ethan, Greg, Ross and Russ who have an RDO on that particular day. To swap with e.g. Ethan, you would enter the following values:

Bob
05-Jan in shift A: 2
05-Jan in shift B: 2

Ethan
05-Jan in shift A: 0
05-Jan in shift B: 1

I'm guessing that Bob and Ethan would have to swap another shift otherwise Ethan would loose out but it is the same principle.

You can add more weeks by simple copying.

Try to populate it with actual data and see if it does what you want.

/Møller

Attached Files

Calendar Example 3.xlsx (67.3 KB, 14 views)