NETWORKDAYS in WPS on Windows: Introduction

WPS NETWORKDAYS is a spreadsheet function for calculating working days between dates; 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
Version limits	None	Available in WPS Spreadsheet on Windows

About This Feature

Overview

NETWORKDAYS is a built-in date calculation function in WPS Spreadsheet on Windows. It is used to count the number of working days between two dates.

Core capabilities include:

Calculate the number of working days between a start date and an end date, excluding Saturday and Sunday by default.
Add an optional holidays argument to exclude specified non-working dates.
Show syntax prompts while you type the function in the formula bar.
Support cross-sheet references and nested formulas, with results recalculated when source data changes.

Typical use cases include project scheduling, attendance tracking, and delivery timeline estimation.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory internet connection is required for local formula calculation
Other	You need to open a WPS Spreadsheet file and have permission to edit cells

Download & Installation

Before using NETWORKDAYS, install WPS Office for Windows and open WPS Spreadsheet.

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office → Open Spreadsheet → Select a cell and type `=NETWORKDAYS(` to confirm that the syntax prompt appears

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, `NETWORKDAYS(start_date,end_date,[holidays])` is used to calculate working days between two dates. It supports an optional holidays argument, cross-sheet references, and nested formulas.	Excel provides `NETWORKDAYS(start_date, end_date, [holidays])` and returns the number of whole working days between two dates, excluding weekends and optional holidays.	Google Sheets provides `NETWORKDAYS(start_date, end_date, [holidays])` to return net working days between two dates, and its help page also points users to related functions such as `WORKDAY` and `NETWORKDAYS.INTL`.	Notion formulas support date properties and functions such as `dateBetween()` for date calculations, but they do not provide a spreadsheet-style `NETWORKDAYS` function with the same syntax.	Adobe Acrobat Sign provides calculated fields that update values dynamically in forms based on entered data, but this is designed for form workflows rather than spreadsheet cell formulas.
WPS Advantages	Advantage: You can enter `NETWORKDAYS` directly in spreadsheet cells and the formula bar, then complete routine workday calculations with syntax prompts, cross-sheet references, and automatic recalculation.	Compared with WPS: Excel offers a directly comparable function with similar syntax, so the main difference is the surrounding office suite and interface workflow.	Compared with WPS: Google Sheets also offers a directly comparable function, but its documentation places more emphasis on date input formats and conversion behavior in web-based sheets.	Compared with WPS: Notion is centered on database properties and page workflows. It can calculate date differences, but it does not focus on spreadsheet cell formulas with a matching function name.	Compared with WPS: Adobe calculated fields are suited to dynamic form logic during signing, not to standard spreadsheet-style workday formulas in cells.
Official Source	—	NETWORKDAYS function	NETWORKDAYS	Formula syntax and functions	Add calculated fields to a form

Overall Conclusion
If your main task is to calculate business days in a spreadsheet for schedules, attendance, or delivery planning, WPS NETWORKDAYS fits directly into a familiar worksheet workflow. Microsoft Excel and Google Sheets provide closely comparable functions, while Notion and Adobe focus more on database logic or form-based calculations than on standard spreadsheet formulas.

Use Cases

No.	Scenario	Suitable for	Core pain point	How NETWORKDAYS helps
1	Project duration tracking	Project managers, operations teams	Need to count actual working days between two dates quickly	Use NETWORKDAYS to calculate workdays between start and end dates
2	Attendance and workday counting	HR teams, administrative staff	Manually excluding weekends and holidays takes time	Add a holidays range to exclude non-working dates automatically
3	Delivery timeline estimation	Sales teams, customer service teams	Hard to estimate promised delivery time quickly	Reference date cells to calculate working-day timelines in real time
4	Combined formula analysis	Finance teams, analysts	Need to reuse workday results in other calculations	Nest NETWORKDAYS inside other formulas for linked analysis

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
NETWORKDAYS formula input and calculation	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Additional advanced benefits	Refer to the current account page for details	Refer to the current account page for details

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday spreadsheet work and basic workday calculation	Free	NETWORKDAYS itself has no membership restriction for common date calculations
Office work that also needs more value-added features	WPS Premium	Suitable if you want broader premium benefits in the same account, with current details shown on the pricing page

WPS membership center: Subscribe now