Others

Create a Three-Weeks-On, One-Week-Off Resource Calendar in Microsoft Project

Algirdas JasaitisAlgirdas Jasaitis Nov 14, 2026 868 views

Question details

Create individual resource calendars for crews working three weeks on and one week off in Microsoft Project.

Create a Three-Weeks-On, One-Week-Off Resource Calendar 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.
Before you start

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.

Solution 1Recommended

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.

1
Create the resources

Open View > Resource Sheet and enter each inspector or crew member as a separate work resource.

2
Select a resource calendar

Go to Project > Change Working Time and select an inspector in the For calendar list.

3
Set working days and hours

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.

4
Enter off-week exceptions

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.

5
Repeat and check assignments

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.

Set up a separate rotating calendar for each resource
Check the schedule after assignments: Resource availability can affect task dates or duration depending on the task type, calendars, and assignment settings. Extend the calendar exceptions if the project end date changes.
Free Microsoft Office alternative

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.

Track inspector work weeks, off weeks, and planned handovers in a spreadsheetOpen and save Microsoft Excel XLSX files for sharingUse a familiar spreadsheet interface to organize rotation datesWork with a lightweight Office suite available for free
microsoft office alternative - wps office

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.