How to Use the NETWORKDAYS Function in WPS on Windows

Use the NETWORKDAYS function through 3 how-to topics, all available without membership; choose a topic from the index to enter the formula, review the syntax, or check the arguments.

How-to Index

How-to Guide

1. Enter NETWORKDAYS from the Insert Function dialog box

Entry path: Formula tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
3. Search for NETWORKDAYS in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter each argument in the Function Arguments dialog box.
6. Click OK to finish inserting the function.

Success Criteria

• The selected cell now contains the NETWORKDAYS function.
• You can see fields for the start date, end date, and optional holiday argument.
• After confirmation, the cell returns a calculation result.

Tips While Using

• Use the English function name NETWORKDAYS when searching.
• Date arguments should be valid date values or valid date references.
• The holiday argument is optional and can refer to a holiday date range.

2. Type the NETWORKDAYS formula directly in a cell

Entry path: Cell → Formula bar

1. Select the target cell.
2. Type =NETWORKDAYS(...) directly in the cell or in the formula bar.
3. Press Enter to confirm.
4. If you want to review the function arguments, type =NETWORKDAYS( and press F1 to view syntax help.

Success Criteria

• The formula is entered in the target cell.
• Pressing Enter returns the working-day result.
• You can continue editing the references in the formula bar.

Tips While Using

• Separate arguments with English commas.
• If the result looks incorrect, check whether the date cells are stored as text.
• When filling the formula across cells, review relative and absolute references.

3. View the NETWORKDAYS syntax and argument details

Entry path: Formula tab → Insert Function

1. Click Insert Function on the Formula tab.
2. Enter NETWORKDAYS in the search box.
3. Select the function to view the syntax: NETWORKDAYS(start_date, end_date, [holidays]).
4. Click the help link for the function to review more details.

Success Criteria

• You can see the full syntax structure of NETWORKDAYS.
• You can distinguish required arguments from the optional argument.
• You can continue entering the function with the argument guidance.

Tips While Using

• start_date and end_date are required arguments.
• [holidays] is optional and is used to exclude additional non-working dates.
• Reviewing the argument details before filling the formula across a sheet can reduce input errors.