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

Last updated:July 23, 2026

Use NETWORKDAYS.PLUS through 3 how-to topics in WPS multi-dimensional tables on Windows; 3 items are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call NETWORKDAYS.PLUSFree
22. Set parameters and exclude holidaysFree
33. Combine NETWORKDAYS.PLUS with other functionsFree

How-to Guide

1. Create a formula field and call NETWORKDAYS.PLUS

Entry path: Add Field → Formula

  1. Open the target multi-dimensional table.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Enter a formula that includes NETWORKDAYS.PLUS in the formula editor.
  5. Click Confirm to save the formula.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • What you can do next: The field shows a calculated result and remains editable.

Tips While Using

  • Common mistake: If you choose Text or Number instead of Formula, you cannot enter the function directly.
  • Environment note: You need edit permission for the current multi-dimensional table.

2. Set parameters and exclude holidays

Entry path: Formula Editor → Function input area

  1. Enter NETWORKDAYS.PLUS in the formula editor.
  2. Fill in the required date-related parameters.
  3. If you need to exclude holidays, add the holiday parameter or reference the related date data based on your table design.
  4. Check the parameter format and save the formula.

Success Criteria

  • Interface result: The formula saves successfully without parameter-format errors.
  • What you can do next: The result updates according to the date and holiday rules you set.

Tips While Using

  • Common mistake: Inconsistent date field formats can cause unexpected results.
  • Environment note: Holiday exclusion depends on whether the date data you provide in the formula is complete.

3. Combine NETWORKDAYS.PLUS with other functions

Entry path: Formula Editor → Combined function input

  1. Start with the basic NETWORKDAYS.PLUS logic in a formula field.
  2. Add other date or conditional functions based on your business needs.
  3. Save the formula and check whether the result updates when record data changes.
  4. If the result is not what you expect, return to the formula editor and adjust the nested logic.

Success Criteria

  • Interface result: The formula field returns a usable result.
  • What you can do next: When source data changes, the result refreshes accordingly.

Tips While Using

  • Common mistake: With deeper nesting, parentheses or parameter order can easily be entered incorrectly.
  • Environment note: For complex formulas, test simple conditions first and expand step by step.