How to Use the NETWORKDAYS Function in WPS on Windows

Last updated:July 17, 2026

Use the NETWORKDAYS function with 4 how-to topics, all available without membership; choose a topic from the How-to Index and follow the entry point and steps to complete it.

How-to Index

#TopicMembership
11. Enter the NETWORKDAYS functionFree
22. Calculate working days with parametersFree
33. Reference dates from another worksheetFree
44. Combine NETWORKDAYS with other formulasFree

How-to Guide

1. Enter the NETWORKDAYS function

Entry point: Top menu bar Formula tab → formula bar

  1. Open WPS Office and go to your spreadsheet file.
  2. Select the cell where you want to show the result.
  3. Type = in the formula bar or directly in the cell.
  4. Continue typing NETWORKDAYS( to view the function syntax hint.

Success Criteria

  • UI state: The formula hint shows the parameter structure for NETWORKDAYS.
  • Next actions: You can continue entering the start date, end date, and optional holidays argument.

Tips While Using

  • Common mistakes: If you do not type = first, the content may be treated as plain text.
  • Environment limits: You need to enter the formula in an editable spreadsheet cell.

2. Calculate working days with parameters

Entry point: Result cell → formula bar

  1. Type =NETWORKDAYS( in the target cell.
  2. Enter the start date argument.
  3. Type a comma, then enter the end date argument.
  4. If needed, continue by entering the holidays argument.
  5. Type the closing parenthesis and press Enter.

Success Criteria

  • UI state: The cell returns the workday calculation result.
  • Next actions: You can copy the formula to other cells for more calculations.

Tips While Using

  • Common mistakes: Missing parentheses, incorrect argument order, or missing separators can cause an error.
  • Environment limits: Date arguments should be valid dates or recognizable date references.

3. Reference dates from another worksheet

Entry point: Result cell → formula bar → cells in another worksheet

  1. Type =NETWORKDAYS( in the result cell.
  2. Switch to the worksheet that contains the start date and select the corresponding cell.
  3. Type the separator, then switch to the worksheet that contains the end date and select the corresponding cell.
  4. If needed, continue selecting a holiday range or type the closing parenthesis.
  5. Press Enter to complete the calculation.

Success Criteria

  • UI state: The formula shows cross-sheet references.
  • Next actions: When you change the source worksheet dates, the result updates automatically.

Tips While Using

  • Common mistakes: Referencing text-formatted dates may cause unexpected results.
  • Environment limits: The related worksheets need to keep valid date data.

4. Combine NETWORKDAYS with other formulas

Entry point: Result cell → formula bar

  1. Enter a combined formula that includes NETWORKDAYS in the target cell.
  2. Nest it inside IF, DATE, or other functions as needed for your scenario.
  3. Check whether each parenthesis pair and argument position is correct.
  4. Press Enter and review the result.

Success Criteria

  • UI state: The cell returns the final result of the combined formula.
  • Next actions: You can continue adjusting the outer formula logic or copy it to other areas.

Tips While Using

  • Common mistakes: When the formula is deeply nested, parenthesis mismatches are more likely.
  • Environment limits: It is recommended to edit longer formulas in the formula bar so you can review the full content.