How to Calculate a Weekday Due Date from Calendar Days in WPS Office Excel
Question details
The user needs an Excel formula that adds a number of calendar days to a start date and returns a valid weekday due date, moving weekend results forward if needed rather than counting business days only.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Calculating delivery, review, or deadline dates from a start date plus a calendar-day lead time.
- Observed behavior
- The resulting due date may fall on a Saturday or Sunday and needs to be adjusted to the next valid weekday.
Confirm that the event date and the added-days cells are formatted as actual dates or numbers, not text. If holidays must be excluded, prepare a separate range containing the holiday dates.
Use WORKDAY to add calendar days and move weekend results to the next weekday
Use this when you need a due date that is a certain number of calendar days after a start date, but must never fall on Saturday or Sunday.
The formula =WORKDAY($C$1+C3-1,1) first adds calendar days to the start date, then shifts the result to the next workday. Saturday and Sunday are treated as non-working days by default, so a weekend due date moves to Monday. To exclude holidays as well, add a holiday range as the third argument, for example =WORKDAY($C$1+C3-1,1,Holidays).
Click the cell where you want the weekday due date to appear, such as D3.
Type =WORKDAY($C$1+C3-1,1) and press Enter. Replace $C$1 with the cell containing the event date and C3 with the cell containing the number of calendar days to add.
To exclude holiday dates, create a range named Holidays, then enter =WORKDAY($C$1+C3-1,1,Holidays) in the due date cell.
Adjust weekend results manually with WEEKDAY and IF
Use this when you want a formula that calculates the raw calendar-day date and moves it forward only when the result is Saturday or Sunday.
Calculate Weekday Due Dates in WPS Office Spreadsheets
Set up a due date formula in WPS Office Spreadsheets that adds calendar days and automatically moves Saturday or Sunday results to the next workday, with optional holiday exclusions using the same WORKDAY function.
- 1. Open your workbook in WPS Office Spreadsheets: Double-click the Excel file, or open WPS Office Spreadsheets and browse to the workbook.
- 2. Select the due date cell: Click the cell where you want the weekday due date to appear.
- 3. Enter the WORKDAY formula: Type =WORKDAY($C$1+C3-1,1) and press Enter, replacing the cell references with your event date and calendar-day offset.
- 4. Optionally add a holiday range: If holidays need to be excluded, define the holiday range and enter =WORKDAY($C$1+C3-1,1,Holidays).
Frequently Asked Questions
Why does =WORKDAY($C$1+C3-1,1) subtract 1 before adding a workday?
The formula calculates the start date plus calendar days minus one day, then WORKDAY adds one workday. This means a result that is already a weekday stays the same, while a Saturday or Sunday result moves forward to the next workday.
How do I exclude holidays from the weekday due date?
Create a range containing the holiday dates, select the range and name it Holidays in the Name Box, then use =WORKDAY($C$1+C3-1,1,Holidays). WPS Office will skip any holiday that falls on the adjusted workday.
What happens when the calendar-day result is already a weekday?
If the calendar-day result is Monday through Friday and not a holiday, WORKDAY returns that same date. It only moves the date when the initial calculation lands on a weekend or an excluded holiday.
Can I use this formula in both WPS Office and Microsoft Excel?
Yes. The WORKDAY function is supported in both applications, so the same formula and workbook can be opened in WPS Office Spreadsheets and Microsoft Excel without modification.
Does this formula count business days only?
No. This method adds calendar days first and then adjusts the result to a valid weekday. If you want to add only business days, use =WORKDAY(start_date,days,holidays) directly without the C3-1 adjustment.
