Create a Linked WPS Spreadsheet Task Schedule That Excludes Weekends
Question details
Create a calendar-style construction schedule where task dates skip weekends and dependent tasks automatically move when a preceding task changes.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user needs to plan tasks in rows with dates across columns, task durations, and predecessor-based scheduling.
- Observed behavior
- Task start and end dates should recalculate automatically from the prior task and exclude Saturday and Sunday.
Set up a table with columns for Task Name, Duration, Start Date, Predecessor, and End Date. Confirm that duration values are whole working days and that all date cells use a recognized date format.
Build a linked task table with WORKDAY formulas
Use this method to calculate each task's working-day start and end dates from its predecessor, so later tasks move automatically when an earlier task changes.
WORKDAY returns a date after a specified number of working days and skips Saturday and Sunday by default. Calculate each task end date from its start date, then use the preceding end date to calculate the next dependent task's start date.
In WPS Spreadsheets, enter headers such as Task Name in A1, Duration in B1, Start Date in C1, Predecessor End Date in D1, and End Date in E1. Enter each task and its duration in working days.
Enter the project start date in C2. In E2, calculate the first task's end date with =WORKDAY(C2,B2-1), which counts the start date as the first working day.
For a task that begins after the previous task ends, enter =WORKDAY(E2,1) in C3. Then enter =WORKDAY(C3,B3-1) in E3 to calculate its end date.
Select C3:E3 and drag the fill handle down for later tasks. Update each row's predecessor reference when a task depends on a different earlier task, such as =WORKDAY(E5,1).
List nonworking holiday dates in a separate range, such as H2:H20. Add that range as the third WORKDAY argument, for example =WORKDAY(E2,1,$H$2:$H$20), to exclude weekends and listed holidays.
Display the task plan as a calendar timeline with conditional formatting
Use this method after calculating task dates to create a calendar-like view with dates across the top and colored bars for each task.
Create a Weekend-Excluding Linked Schedule in WPS Spreadsheets
WPS Spreadsheets lets you create a construction schedule with linked start and end dates, WORKDAY calculations, and conditional-formatting timeline bars. Update a task duration or predecessor date and the dependent schedule can recalculate immediately.
- 1. Create task fields: Open WPS Spreadsheets and add columns for task name, duration, start date, predecessor, and end date.
- 2. Calculate working-day end dates: Enter =WORKDAY(StartDate,Duration-1) in the End Date column to exclude weekends.
- 3. Link dependent starts: Set a dependent start date with =WORKDAY(PreviousTaskEnd,1) or reference the required predecessor row.
- 4. Create the calendar view: Add sequential dates across the top of a separate schedule area and apply conditional formatting to shade dates between each task's start and end date.
Frequently Asked Questions
How do I make Excel or WPS Spreadsheets skip weekends in a task schedule?
Use the WORKDAY function. For example, =WORKDAY(E2,1) returns the next working day after the end date in E2, skipping Saturday and Sunday.
How can I calculate a task end date from its duration?
If the start date is in C2 and duration is in B2, use =WORKDAY(C2,B2-1). Subtracting 1 counts the start date as the first working day.
Can I exclude company holidays as well as weekends?
Yes. Enter holiday dates in a range, such as H2:H20, then use =WORKDAY(C2,B2-1,$H$2:$H$20). Dates in that range are excluded from the calculation.
How do dependent tasks move when an earlier task changes?
Make each dependent Start Date reference the predecessor's End Date, such as =WORKDAY(E2,1). When E2 changes, the dependent start and its calculated end date update automatically.
How can I show schedule tasks as colored bars across dates?
Place dates across the top row, select the timeline grid, and use Home > Conditional Formatting > New Rule with =AND(G$1>=$C2,G$1<=$E2), adjusting cell references for your layout.
