Others

How to Use a 7-Day Project Calendar with a 5-Day Resource Calendar

Olivia MillerOlivia Miller Nov 3, 2026 869 views

Question details

The user needs tasks to run continuously from Monday through Sunday for a 7-day duration, while ensuring resource costs and effort are calculated only for 5 working days.

How to Use a 7-Day Project Calendar with a 5-Day Resource Calendar
Product
Project Management Software
Device & OS
not provided
Scenario
Setting up a project timeline where tasks span across weekends, but assigned resources are only billed for standard weekday working hours.
Observed behavior
A configured timeline where task duration accurately spans 7 calendar days, while the resource cost reports only calculate for 5 days.
Before you start

Ensure you have administrator or editor permissions to access and modify the Resource Sheet and base calendar settings in your project management application before proceeding.

Solution 1Recommended

Configure Custom Calendars and Use Fixed Duration Tasks

By setting up two separate calendars and changing the task type to Fixed Duration, you can separate the overall task timeline from the resource working days.

This approach relies on customizing your project's working days to include weekends while restricting individual resource availability to a standard workweek.

1
Create a 7-day project calendar

Go to your standard calendar settings and modify it so that Saturday and Sunday are marked as working days. Assign this new 7-day calendar as the base for the overall project.

2
Create a 5-day resource calendar

Create a new custom calendar named 'Five-day week' where weekends are designated as non-working days.

3
Assign the calendar to resources

Navigate to the Resource Sheet in your application and assign the newly created 'Five-day week' calendar to the relevant personnel or resources.

4
Set task to Fixed Duration

Select the affected tasks in your project plan, open the task properties or settings, and change the task type to 'Fixed Duration'.

5
Assign resources to the task

When you assign a resource to a 7-day task, the system will now use the 5-day calendar to calculate work and cost, ensuring cost reports reflect only five days of effort.

Configure Custom Calendars and Use Fixed Duration Tasks
Calculation Accurate: Your cost reports will now correctly calculate five working days instead of seven, while preserving the continuous weekly task timeline on your Gantt chart.
Free Microsoft Office alternative

Easily Manage Project Schedules with WPS Office

If you don't need complex enterprise project management software, WPS Office provides an excellent, free alternative. Use WPS Spreadsheet to track 7-day timelines and calculate 5-day resource costs using built-in formulas, all within a familiar, lightweight interface.

  1. 1. Download and install: Download WPS Office for free from the official website and install it on your computer or mobile device.
  2. 2. Open a project template: Launch WPS Spreadsheet, go to the template library, and search for 'Project Schedule' or 'Gantt Chart' to get started quickly.
  3. 3. Calculate resource costs: Use the NETWORKDAYS formula to automatically calculate 5-day working costs while visually displaying a full 7-day calendar timeline.
100% free and lightweight productivity suite.High compatibility with Microsoft Excel, Word, and PowerPoint formats.Access to hundreds of free project schedule and Gantt chart templates.Built-in formulas to easily calculate working days (e.g., NETWORKDAYS).
microsoft office alternative - wps office

Frequently Asked Questions

What does 'Fixed Duration' mean in project management software?

A Fixed Duration task ensures that the total time allocated to complete a task remains constant. Adding more resources or changing their work calendars will not shorten or lengthen the established task timeline.

Why are my resource costs calculating for weekends?

This occurs if your resource base calendar matches the project calendar, which includes weekends. You must explicitly assign a separate 5-day workweek calendar to the resources in the Resource Sheet to prevent weekend billing.

Can I use standard spreadsheets for this kind of project scheduling?

Yes. In spreadsheet applications like WPS Spreadsheet, you can list task start and end dates spanning 7 days, and use functions like NETWORKDAYS to calculate costs based only on Monday-Friday working days, ignoring weekends and holidays.