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

Use NETWORKDAYS.INTL in 4 topics, all available without membership in WPS Sheets for Windows; choose a topic from the How-to Index and follow the steps.

How-to Index

How-to Guide

1. Enter the NETWORKDAYS.INTL function

Entry point: Worksheet area → target cell → formula bar

1. Open WPS Sheets and select the cell where you want to display the result.
2. Type = in the cell or formula bar.
3. Continue by typing NETWORKDAYS.INTL(.
4. Check the syntax hint to confirm that the function name is recognized.

Success Criteria

• UI state: The cell enters formula input mode and shows a NETWORKDAYS.INTL-related hint.
• Next actions: You can continue entering arguments and complete the calculation.

Tips While Using

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

2. Set the start date, end date, and weekend argument

Entry point: Target cell → formula bar

1. Enter the start date argument inside the function parentheses.
2. Type a comma and enter the end date argument.
3. Add the weekend argument as needed to define which days are treated as rest days.
4. Check the parentheses and separators, then press Enter.

Success Criteria

• UI state: The cell returns a working-day calculation result.
• Next actions: You can edit the formula again or copy it to other cells.

Tips While Using

• Common mistakes: An incorrect argument order or a missing separator can cause a formula error.
• Environment limits: Date arguments should remain in a valid date format for calculation.

3. Add a holiday argument to exclude non-working days

Entry point: An existing NETWORKDAYS.INTL formula

1. After the start date, end date, and weekend argument, continue by entering the holiday argument.
2. Set the holiday argument as a single date or a referenced holiday range.
3. Confirm that all dates to exclude are included in the argument range.
4. Press Enter to update the result.

Success Criteria

• UI state: The result excludes holidays from the working-day total.
• Next actions: You can edit the holiday range and recalculate.

Tips While Using

• Common mistakes: If the holiday range contains invalid text values, the result may not match expectations.
• Environment limits: It is recommended to keep holiday data in a continuous cell range.

4. Use cell references for batch calculation

Entry point: Result cell with a completed formula → fill handle

1. Use cell references for the start date, end date, and holiday data in the formula.
2. Confirm that the first result is correct, then select that result cell.
3. Drag the fill handle downward to copy the formula to other rows.
4. Check whether each row updates with its referenced data.

Success Criteria

• UI state: Multiple rows show their corresponding working-day results.
• Next actions: If you change any referenced date, the result updates accordingly.
• No side effects: The original date data is not overwritten when the formula is copied.

Tips While Using

• Common mistakes: Incorrect absolute or relative references can shift the result unexpectedly.
• Environment limits: Before batch calculation, confirm that the referenced range uses a consistent format.