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

This how-to guide includes 4 operation topics, all available without membership, so you can jump from the index to the exact task you need.

How-to Index

How-to Guide

1. Enter a basic NETWORKDAYS.INTL formula

Entry point: Formulas tab → formula bar

1. Open WPS Spreadsheet and select the cell where you want the result to appear.
2. Type = to begin the formula.
3. Type NETWORKDAYS.INTL( and review the function guidance.
4. Enter the start date and end date arguments.
5. Type the closing parenthesis and press Enter to return the result.

Success Criteria

• The cell returns a working-day result.
• Function guidance appears after the function name is entered.
• The result updates automatically when the date values change.

Tips While Using

• Date arguments should be valid dates or references to date cells.
• The formula must begin with =.

2. Set a custom weekend parameter

Entry point: result cell → formula bar

1. In the existing formula, add the third argument after the first two date arguments.
2. Use a numeric code to define the weekend type, or enter a 7-character text string to define workdays and weekends.
3. Make sure the arguments are separated correctly.
4. Press Enter to update the result.

Success Criteria

• The formula returns a valid result.
• The workday total changes when the weekend parameter changes.

Tips While Using

• The 7-character text string should follow the weekly order used by the function.
• If the parameter format is incorrect, the formula may return an error.

3. Add a holiday range

Entry point: result cell → formula bar

1. Prepare a list of holiday dates in the worksheet.
2. Add the holiday range argument in the formula.
3. Select the holiday cell range as the reference.
4. Press Enter and review the updated result.

Success Criteria

• Holiday dates are excluded from the workday count.
• The result changes when the holiday range is updated.

Tips While Using

• Values in the holiday range should be valid dates.
• Avoid mixing text or non-date values into the holiday range.

4. Use cross-sheet references and nested formulas

Entry point: formula bar

1. Reference date cells from another worksheet in the formula arguments.
2. Combine NETWORKDAYS.INTL with other functions when needed.
3. Check that the references and parentheses are complete.
4. Press Enter to finish the calculation and confirm that updates flow through when source data changes.

Success Criteria

• The formula correctly references data from another worksheet.
• The nested formula returns a result and remains editable.

Tips While Using

• Confirm that worksheet names and cell references are correct for cross-sheet formulas.
• For longer formulas, edit in the formula bar for easier review.