How to Use a 7-Day Project Calendar with a 5-Day Resource Calendar
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.

- 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.
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.
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.
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.
Create a new custom calendar named 'Five-day week' where weekends are designated as non-working days.
Navigate to the Resource Sheet in your application and assign the newly created 'Five-day week' calendar to the relevant personnel or resources.
Select the affected tasks in your project plan, open the task properties or settings, and change the task type to 'Fixed Duration'.
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.

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. Download and install: Download WPS Office for free from the official website and install it on your computer or mobile device.
- 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. Calculate resource costs: Use the NETWORKDAYS formula to automatically calculate 5-day working costs while visually displaying a full 7-day calendar timeline.

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.




