How to Use the NETWORKDAYS Function in WPS on Windows

Use NETWORKDAYS with 4 how-to topics, all available without membership, and jump to each topic from the How-to Index.

How-to Index

How-to Guide

1. Enter the NETWORKDAYS function

Entry point: Formulas tab → Formula bar

1. Open WPS Spreadsheet and select the cell where you want to show the result.
2. Type = in the cell or formula bar.
3. Continue by typing NETWORKDAYS(.
4. Check whether the function name and argument prompt appear.

Success Criteria

• Interface result: The cell enters formula input mode and shows NETWORKDAYS(.
• Next action available: You can continue entering the start date, end date, and optional holidays argument.

Tips While Using

• Common mistake: If you do not type = first, the content may be treated as plain text.

2. Fill in arguments with the syntax prompt

Entry point: Formula bar after selecting the target cell

1. After NETWORKDAYS(, enter the start date argument first.
2. Type a separator and then enter the end date argument.
3. Check the argument order and format with the syntax prompt.
4. 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 select the cell again to review or edit the formula.

Tips While Using

• Common mistake: Missing a closing parenthesis or separator can cause a formula error.

3. Add a holidays range to the formula

Entry point: Formula bar

1. Enter =NETWORKDAYS(start_date,end_date,holidays_range).
2. Set the holidays range to a cell range that contains holiday dates.
3. Press Enter to confirm.
4. Check whether the result excludes the specified holidays.

Success Criteria

• Interface result: The result changes compared with the version that does not include a holidays argument.
• Next action available: When you update the holidays range, the result updates as well.

Tips While Using

• Common mistake: If the holidays range contains non-date content, the result may not match expectations.

4. Use cross-sheet references and nested formulas

Entry point: Formula bar

1. Enter a NETWORKDAYS formula in the current worksheet.
2. Reference the start date or end date from cells in another worksheet.
3. If needed, nest the NETWORKDAYS result inside another formula.
4. Change the referenced data and check whether the result recalculates automatically.

Success Criteria

• Interface result: Cross-sheet references work normally, and the result updates when source data changes.
• Next action available: You can copy the formula or extend it to more cells.

Tips While Using

• Common mistake: If a referenced cell does not contain a valid date, the result may return an error value.