NETWORKDAYS.PLUS in WPS on Windows FAQ

Last updated:July 20, 2026

This FAQ covers 4 common questions about entering the formula, checking parameters, validating results, and using references in WPS Spreadsheet on Windows, followed by a short glossary of key terms.

FAQ

What should I do if NETWORKDAYS.PLUS returns an error?

  1. Check whether the formula starts with =.
  2. Check the function spelling, parentheses, and comma separators.
  3. Confirm that the start-date and end-date parameters are in the correct positions.
  4. If you use a holiday parameter, make sure the referenced values are valid dates.

How can I view the parameter prompt for NETWORKDAYS.PLUS?

  1. Select the target cell and type =.
  2. Type NETWORKDAYS.PLUS(.
  3. Watch the formula area for the syntax prompt.
  4. Enter the parameters in order and complete the formula.

Why is the calculated result different from what I expected?

  1. Check whether the start date and end date were entered in reverse order.
  2. Confirm whether the holiday parameter includes the dates that should be excluded.
  3. Check whether the date cells are stored as text.
  4. Review whether your business rule should use working days instead of calendar days.

Can I combine NETWORKDAYS.PLUS with other formulas?

  1. Yes. You can reference the results of other cells in the parameters.
  2. You can also use this function as part of a larger formula.
  3. When combining formulas, verify each referenced value first.
  4. Then confirm the final result together.

Glossary

TermDefinition
Working dayA date counted for work or project execution, usually excluding weekends.
Holiday parameterAn extra date list or range passed into the function so specified dates are excluded from the workday count.
Cross-sheet referenceA formula reference that points to a cell or range in another worksheet.
Automatic recalculationFormula results update automatically when referenced data changes.