NETWORKDAYS.INTL is a date calculation function in WPS Sheets that counts working days between two dates with custom weekend rules; 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 |
| Version limits | No specific limit stated | No required version threshold is listed |
| Membership limits | None for this function | You can use it directly in WPS Sheets |
About This Feature
Overview
NETWORKDAYS.INTL is a built-in function in WPS Office for Windows Sheets. It is used to calculate the net number of working days between two dates and supports custom non-working day rules through either a weekend number or a seven-character string.
Core tasks include:
- Insert NETWORKDAYS.INTL from the Insert Function dialog when you want to review parameters while entering the formula.
- Type
=NETWORKDAYS.INTL(...)directly in a cell or in the formula bar for everyday spreadsheet work. - Review the syntax
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])to confirm argument order and optional parameters.
This function is useful for attendance tracking, project scheduling, cross-region business-day calculations, and holiday exclusion scenarios. It helps reduce manual counting and keeps date calculations consistent when different weekend rules apply.
System Requirements
| Item | Requirement |
|---|---|
| OS | A Windows device that can run WPS Office |
| App version | It is recommended to use the latest version of WPS Office for full formula input and help-panel support |
| Network | No mandatory internet connection is required for local formula entry; internet access is needed for the download page or online help |
| Other | WPS Sheets must be installed, and you need permission to edit the worksheet |
Download & Installation
Before using NETWORKDAYS.INTL, install WPS Office on your Windows device and open WPS Sheets.
| Item | Details |
|---|---|
| Official Download | WPS Office Free Download |
| Post-install Check | Launch WPS Sheets, open any workbook, and confirm that the Formulas tab and formula bar are available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) in WPS Sheets for net workday calculations, with both dialog-based insertion and direct formula entry. | Excel provides the same NETWORKDAYS.INTL function and supports weekend numbers, seven-character weekend strings, and holiday arguments. | Google Sheets provides the same NETWORKDAYS.INTL function, supports number or string weekend definitions, and can use a holiday range. | Notion formulas support date functions such as dateBetween() for date differences, but there is no same-name spreadsheet function and no cell-based formula workflow. | Adobe Acrobat Sign supports calculated fields that update form values dynamically during signing, but it is designed for form workflows rather than spreadsheet workday functions. |
| WPS Advantages | Advantage: On Windows, WPS Sheets lets you calculate business days directly in a worksheet through either the function dialog or direct cell entry, which fits scheduling and attendance scenarios in spreadsheets. | Compared with WPS: Offers similar function coverage, but it is centered on the Excel worksheet environment. | Compared with WPS: Also supports the same function, but it is more closely tied to online spreadsheet use and has its own date-text interpretation behavior. | Compared with WPS: Can calculate date differences, but it does not provide a NETWORKDAYS.INTL worksheet function entry point or a parameter dialog that matches spreadsheet workflows. | Compared with WPS: Calculated fields are better suited to signing forms and document workflows than batch worksheet calculations. |
| Official Source | — | NETWORKDAYS.INTL function | NETWORKDAYS.INTL | Formula syntax & functions | Add calculated fields to a form |
Overall Conclusion: If your work focuses on spreadsheet-based business-day counting, weekend-rule adjustments, and holiday exclusions, NETWORKDAYS.INTL in WPS Sheets covers common calculation needs directly. Microsoft Excel and Google Sheets offer closely related function support, while Notion and Adobe are better aligned with database formulas or form-based calculations.
Use Cases
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | Attendance workday counting | HR and administrative staff | They need to count attendance days under different weekend rules | Use NETWORKDAYS.INTL with a weekend argument to calculate net working days |
| 2 | Project schedule estimation | Project managers and operations teams | They need to exclude weekends and holidays when estimating timelines | Add the holidays argument to exclude holiday dates |
| 3 | Cross-region business-day calculation | Finance and supply chain teams | Different regions use different weekend patterns, so manual counting is error-prone | Use a weekend number or a seven-character string to define non-working days |
| 4 | Template-based report calculation | Data analysts | They need to reuse the same rule across many rows | Enter the formula once and fill it down across the target range |
| 5 | Function learning and validation | New users | They are unsure about argument order and syntax | Use Insert Function and the parameter window to review the function details |
Membership & Benefits
Free vs WPS Premium
| Feature | Free User | WPS Member |
|---|---|---|
| Use basic WPS Sheets functions | ✅ | ✅ |
| Use NETWORKDAYS.INTL for workday calculations | ✅ | ✅ |
| PDF conversion, more templates, and broader office tools | Some features are limited | More features are available |
| Cloud storage | 1 GB | 20 GB or more depending on plan |
| AI tools | Some features are limited | More features and usage scope are available |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| Everyday spreadsheet calculations and formula learning | Free | NETWORKDAYS.INTL itself is available directly and works well for basic office tasks and learning |
| More cloud storage, PDF tools, or broader office features | WPS Premium | Suitable for users who also need PDF, templates, cloud storage, and expanded office capabilities |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page