Create a Three-Weeks-On, One-Week-Off Resource Calendar in Microsoft Project
Question details
Create individual resource calendars for crews working three weeks on and one week off in Microsoft Project.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Several inspectors rotate through assignments and need individual availability schedules and planned handovers.
- Observed behavior
- Tasks assigned during an inspector's off week may be delayed or have their scheduled duration affected. The user wants predictable rotations and handovers.
Identify each inspector's rotation start date, daily working hours, off-week dates, and expected project end date. Decide whether inspectors work every day during their three-week period or follow a standard workweek.
Set up a separate rotating calendar for each resource
Use resource calendars to show each inspector's working and nonworking periods through the project end date.
Open View > Resource Sheet and enter each inspector or crew member as a separate work resource.
Go to Project > Change Working Time and select an inspector in the For calendar list.
On the Work Weeks tab, select the applicable work week and click Details. Set the working days and hours for the inspector's three-week working period.
On the Exceptions tab, add a named nonworking exception with the start and finish dates of the inspector's first off week. Add subsequent off weeks at four-week intervals through the project end date.
Repeat the calendar setup for each inspector using that person's rotation dates. Assign resources to tasks in the Gantt Chart and check scheduled dates when assignments cross an off week.

Plan handovers with separate task assignments
Use explicit work segments when another inspector must take over during an off week.
Track inspector rotations in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface. Use WPS Spreadsheets to maintain a rotation and handover table in an Excel-compatible file for easy sharing and migration. It does not replace Microsoft Project resource scheduling.

Frequently Asked Questions
How do I give each inspector a different rotation?
Create each inspector in View > Resource Sheet, then select that person under Project > Change Working Time. Enter off-week exceptions based on the inspector's own rotation dates.
Does three weeks on mean the inspector works every day?
Not necessarily. In Project > Change Working Time, use the Work Weeks tab and Details to set the actual working days and hours during the three-week period.
Will Project automatically assign another inspector during an off week?
No. Plan the handover yourself, for example by creating separate task segments in the Gantt Chart and assigning an available inspector to each segment.
Why did a task's dates or duration change after I assigned an inspector?
The resource's nonworking time can affect scheduling. Check the resource calendar under Project > Change Working Time, and review the task type, calendar, and assignments in the task's information and scheduling views.
What happens if the project runs past the last entered off week?
The resource calendar may no longer reflect the rotation. Return to Project > Change Working Time and add the remaining off-week exceptions through the new project end date.




