NETWORKDAYS.INTL in WPS on Windows: Introduction

NETWORKDAYS.INTL is a date calculation function in WPS Spreadsheet; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

NETWORKDAYS.INTL is a built-in function in WPS Spreadsheet on Windows for calculating the number of working days between two dates. It supports custom weekend rules and holiday ranges, making it useful for attendance tracking, project scheduling, delivery planning, and finance workflows.

Core capabilities include:

Calculate net working days between two dates.
Use numeric or text parameters to define weekend rules.
Exclude holidays through a referenced date range.
Support cross-sheet references and nested formulas with automatic recalculation when data changes.

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
Network	No required internet connection for local formula calculation; internet is needed for download, installation, and account services
Other	WPS Spreadsheet and permission to edit the worksheet

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Spreadsheet, create or open a worksheet, and type `=NETWORKDAYS.INTL(` in a cell to confirm that function guidance appears

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides the NETWORKDAYS.INTL function to calculate working days between two dates, with support for custom weekends, holiday ranges, cross-sheet references, and nested formulas.	Excel provides the NETWORKDAYS.INTL function to return the number of whole workdays between two dates and lets users specify weekend days.	Google Sheets provides the NETWORKDAYS.INTL function with start date, end date, weekend, and holiday parameters.	Notion formulas support date functions such as dateBetween and dateAdd for date logic, but there is no spreadsheet-style NETWORKDAYS.INTL function.	Adobe Acrobat Sign provides calculated fields that update form values dynamically, but this is designed for form workflows rather than spreadsheet functions.
WPS Advantages	Advantage: Handles workday calculations directly in spreadsheet cells for scheduling, analysis, and recurring data workflows; also supports cross-sheet references and automatic recalculation.	Compared with WPS: Offers a direct equivalent function and fits Excel workbook workflows.	Compared with WPS: Also offers a direct equivalent function and fits browser-based collaboration.	Compared with WPS: Can handle date logic in databases, but bulk cell-based formula analysis is less direct than spreadsheet formulas.	Compared with WPS: Focuses on dynamic fields in signing forms rather than routine spreadsheet-based workday analysis.
Official Source	—	NETWORKDAYS.INTL function	NETWORKDAYS.INTL	Formula syntax & functions	Add calculated fields to a form

Overall Conclusion
For spreadsheet-based workday counting, scheduling, and date interval analysis, NETWORKDAYS.INTL in WPS fits everyday worksheet workflows well. Microsoft Excel and Google Sheets provide direct equivalent functions, while Notion and Adobe are better aligned with database or form-specific use cases.

Use Cases

No.	Scenario	Suitable for	Main challenge	How it helps
1	Attendance workday counting	HR, admin teams	Need to exclude weekends and holidays from attendance periods	Use NETWORKDAYS.INTL with a holiday range to calculate net working days
2	Project delivery scheduling	Project managers, operations teams	Need to calculate timelines under different weekend rules	Set weekend parameters and return the total number of working days
3	Financial cycle calculation	Finance, audit teams	Settlement periods cannot be measured by calendar days alone	Exclude non-working days to get effective business-day totals
4	Cross-sheet date analysis	Data analysts	Date fields across multiple sheets need consistent calculation	Combine cross-sheet references and nested formulas for automatic results

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
NETWORKDAYS.INTL calculation	✅	✅
Basic spreadsheet editing	✅	✅
Advanced PDF and additional value-added features	Depends on the feature	More features available
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday formula work and basic spreadsheet editing	Free	NETWORKDAYS.INTL itself has no membership restriction and can be used directly
Need more cloud storage or broader feature access	WPS Premium	Suitable for users who also need more document, PDF, and cloud-related capabilities

WPS membership center: Subscribe now