Function Problems

How to Exclude the Starting Date from NETWORKDAYS in WPS Office Excel

Tauseeq MagsiTauseeq Magsi Nov 13, 2026 868 views

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.

How to Exclude the Starting Date from NETWORKDAYS in WPS Office Excel
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.
Before you start

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.

Solution 1

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.

1
Select the result cell

Click the cell where you want the working-day count to appear.

2
Enter the adjusted formula

Type =NETWORKDAYS(A1,A2)-1 and press Enter. Replace A1 and A2 with your actual start and end date cells.

Result excludes the starting date: The formula subtracts one working day from the NETWORKDAYS result, which removes the counted start date.
Excel-compatible date function

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. 1. Open your workbook: Launch WPS Office and open the spreadsheet that contains your start and end dates.
  2. 2. Select the result cell: Click the cell where you want the working-day count to be displayed.
  3. 3. Enter the NETWORKDAYS formula: Type =NETWORKDAYS(A1,A2)-1 or =NETWORKDAYS(A1+1,A2) and press Enter.
  4. 4. Adjust the cell references: Replace A1 and A2 with the actual cells that hold your start date and end date.
Uses the familiar NETWORKDAYS function for accurate working-day calculationsFull compatibility with Microsoft Excel .xlsx formulas and date functionsFree to use with a familiar Office-style spreadsheet interfaceEasy formula adjustment without replacing your existing workbook
QA img-9

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.