How to Use the NETWORKDAYS.PLUS Function in WPS on Windows

Last updated:July 20, 2026

This how-to guide includes 4 operation topics for NETWORKDAYS.PLUS in WPS Spreadsheet on Windows; all 4 are available without membership and 0 are membership-related, so you can jump to any topic from the index below.

How-to Index

No.TopicMembership Requirement
11. Enter the NETWORKDAYS.PLUS functionFree
22. Complete a workday calculation with parametersFree
33. Reference cells or other worksheetsFree
44. Check the result and trigger recalculationFree

How-to Guide

1. Enter the NETWORKDAYS.PLUS function

Entry point: Spreadsheet → target cell → formula bar

  1. Open WPS Office and go to Spreadsheet.
  2. Select the cell where you want to display the result.
  3. Type = in the formula bar or directly in the cell.
  4. Continue by typing NETWORKDAYS.PLUS(.
  5. Review the syntax prompt and confirm the function name and parameter order.

Success Criteria

  • Interface result: The cell enters formula-editing mode and shows the function name.
  • Next action available: You can continue entering the start date, end date, and optional parameters.

Tips While Using

  • Common mistake: If you forget to type = first, the content may be treated as plain text.
  • Environment note: You need to work in an editable spreadsheet cell.

2. Complete a workday calculation with parameters

Entry point: A cell or formula bar with the function already entered

  1. Enter the start-date parameter in the function.
  2. Type a comma and enter the end-date parameter.
  3. If needed, add the holiday range or holiday values as another parameter.
  4. Check that the parentheses and separators are complete.
  5. Press Enter to confirm the formula.

Success Criteria

  • Interface result: The cell shows a calculated result instead of plain formula text.
  • Next action available: You can copy the formula to other cells if needed.

Tips While Using

  • Common mistake: Missing parentheses, incorrect parameter order, or missing separators can cause an error.
  • Environment note: Date parameters should use a recognizable date format.

3. Reference cells or other worksheets

Entry point: Formula bar → cell references

  1. In the parameter position, click the cell that contains the start date.
  2. Select the cell that contains the end date.
  3. If you need a cross-sheet reference, switch to the target worksheet and select the required cell or range.
  4. Press Enter to apply the formula.

Success Criteria

  • Interface result: The formula shows cell references or cross-sheet references.
  • Next action available: When the source cells change, the result updates accordingly.

Tips While Using

  • Common mistake: Referencing text instead of valid date values can affect the result.
  • Environment note: For cross-sheet references, make sure the referenced worksheet still exists.

4. Check the result and trigger recalculation

Entry point: Result cell → edit source data → recalculate

  1. Check whether the result cell returns the expected number of working days.
  2. Edit the source data for the start date, end date, or holiday parameter.
  3. Watch whether the result updates automatically.
  4. If you want to confirm the formula again, review it and press Enter once more.

Success Criteria

  • Interface result: The result changes when the source data changes.
  • Next action available: You can continue using the result for scheduling, reporting, or copying to other areas.

Tips While Using

  • Common mistake: Entering dates as text may cause unexpected results.
  • Environment note: In complex sheets, confirm the reference range before filling the formula across many cells.