NETWORKDAYS.PLUS in WPS is a formula feature for calculating working days in WPS multi-dimensional tables, including holiday exclusion; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
| Platform | Windows | For WPS Office on Windows in multi-dimensional table scenarios |
About This Feature
Overview
NETWORKDAYS.PLUS is a formula function in WPS multi-dimensional tables. It is used to calculate the number of working days between dates and can exclude holidays when needed. You can add it in a formula field and combine it with other functions for schedule tracking, attendance calculations, and business-day duration analysis.
Core capabilities include:
- Use
NETWORKDAYS.PLUSin a formula field to calculate working days. - Exclude holidays to better match real business calendars.
- Combine it with other functions to build more complete date logic.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | The latest version of WPS Office is recommended for newer multi-dimensional table and formula features |
| Network | Internet access is usually needed for installation and account sign-in; local formula editing does not always require a connection after setup |
| Other | You need an editable multi-dimensional table and permission to add fields and edit formulas |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Office, enter a multi-dimensional table, and confirm that you can add a Formula field and open the formula editor |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Calculates working days in a formula field inside a multi-dimensional table, supports holiday exclusion, and can be combined with other functions. | Excel NETWORKDAYS returns the number of whole working days between two dates and supports an optional holidays argument. | Google Sheets NETWORKDAYS returns the number of net working days between two dates and supports an optional holidays argument. | Notion formulas support date functions such as dateBetween, but there is no native NETWORKDAYS function, so users usually build the logic manually. | Adobe Acrobat Sign supports calculated fields in forms, but this is a form-expression workflow rather than a native spreadsheet workday function. |
| WPS Advantages | Advantage: You can calculate workdays directly in a multi-dimensional table formula field and apply holiday exclusion rules in the same record workflow. Distinct: The result can be shown directly in a record field for table-based tracking. | Compared with WPS: Excel offers a similar workday function, but it is mainly designed for spreadsheet cell formulas. | Compared with WPS: Google Sheets also provides a similar function and is well suited to browser-based spreadsheet workflows. | Compared with WPS: Notion requires users to assemble the logic with general date functions, which usually takes more setup. | Compared with WPS: Adobe focuses on form calculations during signing workflows rather than spreadsheet-style function scenarios. |
| Official Source | — | Excel NETWORKDAYS function | Google Sheets NETWORKDAYS | Notion formula syntax | Adobe calculated fields |
Overall Conclusion
If your main goal is to calculate business days directly inside table records, WPS provides a workflow that fits formula-field scenarios well. Microsoft Excel and Google Sheets offer mature equivalent functions, while Notion and Adobe are better viewed as adjacent solutions rather than direct spreadsheet-function matches.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How this helps |
|---|---|---|---|---|
| 1 | Project schedule tracking | Project managers and collaborators | You need to count actual working days between two dates | Use NETWORKDAYS.PLUS in a formula field to calculate workdays |
| 2 | Attendance and leave calculations | HR and administrative teams | You need to exclude holidays when counting valid workdays | Add holiday-related parameters or references in the formula |
| 3 | Business processing duration | Operations and support teams | You need to measure turnaround time by workdays instead of calendar days | Combine NETWORKDAYS.PLUS with other functions |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
Use NETWORKDAYS.PLUS in multi-dimensional tables | Available | Available |
| Core office components | Available | Available |
| Some advanced PDF, AI, and extended benefits | Limited or available with restrictions shown on the pricing page | More advanced features and higher quotas are available |
| Cloud storage | 1 GB | Higher-capacity plans are available |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| You mainly need formula functions for everyday table calculations | Free plan | NETWORKDAYS.PLUS itself is available for routine calculation needs |
| You also need more advanced office, PDF, or AI-related features | WPS Premium | A better fit for users who need broader office capabilities, more cloud storage, or added tools |
How to Subscribe
- Visit the WPS membership page, choose a plan that fits your needs, and complete the purchase: Subscribe to WPS
Source: WPS Office pricing page