Rota Pattern HELP!!!!

[robzbase]

All,

I am trying to create a table to display name of employees and their relevant rota. Attached is a spreadsheet as an example of one rota I have.

The rota at the top gives the 3 week rotation, the table underneath is the names and which week they start on and what week.

Trying to create a table at the bottom that when I put someones name in and change the date it will populate his rota for that day/week.

I have loads of different rotation plans and need to have them all together when I enter a date.

Can someone please help?

[Tsjallie]

Maybe the formula I put in your workbook helps. Though it's not a very nice formula