How to Exclude the Starting Date from NETWORKDAYS in WPS Office Excel
Question details
The user needs to calculate the number of working days between two dates in WPS Office Excel while excluding the starting date from the result.

- Product
- WPS Office Excel
- Device & OS
- not provided
- Scenario
- Calculating working days with NETWORKDAYS but not counting the starting date.
- Observed behavior
- NETWORKDAYS includes both the start date and end date when they are working days, so the result is one day more than expected when the start date should be excluded.
Confirm that your start date and end date are stored in date-formatted cells, such as A1 and A2, and decide whether the end date should still be counted in the working-day total.
Subtract 1 from the NETWORKDAYS result
Use this option when you want a simple adjustment to the existing formula while keeping the original start date reference.
Click the cell where you want the working-day count to appear.
Type =NETWORKDAYS(A1,A2)-1 and press Enter. Replace A1 and A2 with your actual start and end date cells.
Shift the start date forward by one day in NETWORKDAYS
Use this option when the starting date should never be evaluated, regardless of whether it falls on a weekday, weekend, or holiday.
Calculate working days without the start date in WPS Office Excel
Use the built-in NETWORKDAYS function in WPS Office Excel to compute working days while excluding the starting date. WPS Office keeps formulas compatible with Microsoft Excel, so you can apply the same date functions without changing your workflow.
- 1. Open your workbook: Launch WPS Office and open the spreadsheet that contains your start and end dates.
- 2. Select the result cell: Click the cell where you want the working-day count to be displayed.
- 3. Enter the NETWORKDAYS formula: Type =NETWORKDAYS(A1,A2)-1 or =NETWORKDAYS(A1+1,A2) and press Enter.
- 4. Adjust the cell references: Replace A1 and A2 with the actual cells that hold your start date and end date.

Frequently Asked Questions
Why does NETWORKDAYS count the starting date?
NETWORKDAYS treats both start_date and end_date as inclusive when they fall on working days. This is the standard behavior in Microsoft Excel and WPS Office Excel.
Which formula should I use if the start date may fall on a weekend?
Use =NETWORKDAYS(A1+1,A2). The +1 shifts the evaluation window to the day after the start date, so the original start date is never evaluated even if it falls on a weekend or holiday.
Can I still exclude holidays while excluding the starting date?
Yes. Add the holiday range as the third argument, for example =NETWORKDAYS(A1+1,A2,B1:B10) or =NETWORKDAYS(A1,A2,B1:B10)-1, where B1:B10 contains holiday dates.
Does this formula work the same way in WPS Office and Microsoft Excel?
Yes. WPS Office uses the same NETWORKDAYS function, so these formulas can move between WPS Office Excel and Microsoft Excel without changes.





