Excel Crew Rotation Calendar

I’m building a weekly crew-rotation calendar in Excel and I want everything driven by formulas—no VBA or macros at all. The sheet needs to let me enter each person’s name, role / responsibility and whether they are available for Sunday shifts, then automatically generate a clear roster that rotates the team week by week.

Here’s what I have in mind:
- A simple data entry table for crew details (name, role, Sunday-work flag).
- A separate view that auto-populates the coming week’s schedule based on those details, spreading people evenly while respecting their Sunday availability.
- Consider holidays and possible PTO addition.
- Formulas that handle the rotation logic so I can extend the calendar by dragging the fill handle or copying sheets for future weeks.

If it’s possible to highlight gaps or duplicate assignments with conditional formatting, that would be a bonus, but again, I’d like this achieved purely with standard Excel functions (e.g., INDEX, MATCH, SORT, FILTER, SEQUENCE).

Once the sheet is finished, I should be able to:
– Add or remove crew members without breaking the rotation.
– Change the “week starting” date and have the schedule update automatically.
– Print or share a clean, easy-to-read rota for the team.

Please deliver the working .xlsx file plus a brief note explaining the key formulas so I can maintain it myself.