NETWORKDAYS.PLUS in WPS on Windows: Introduction

WPS NETWORKDAYS.PLUS is a spreadsheet date function for counting working days between two dates with optional holiday references; 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 How-to Index
Membership-related items	0	Matches the number of membership-related rows in the How-to Index

About This Feature

Overview

NETWORKDAYS.PLUS is a built-in function in WPS Spreadsheet on Windows for calculating working days in schedules, attendance sheets, project timelines, and delivery planning.

Core capabilities include:

Enter the function and review syntax prompts while building a formula.
Calculate working days with a start date, end date, and optional holiday references.
Use cell references across worksheets and combine the function with other formulas.
Recalculate results automatically when referenced data changes.

This function is useful for HR attendance tracking, project duration planning, finance date calculations, and everyday spreadsheet analysis.

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 mandatory internet connection is required for local formula calculation; internet access is needed for download, installation, and account-related actions
Other	You need permission to open and edit spreadsheet files and enter formulas in cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office → open Spreadsheet → select a cell and type `=NETWORKDAYS.PLUS(` to confirm that formula input and syntax prompts are available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, NETWORKDAYS.PLUS can be entered directly in a cell for working-day calculations with syntax prompts, cross-sheet references, and automatic recalculation.	Excel provides `NETWORKDAYS` and `NETWORKDAYS.INTL` to return whole workdays between dates and supports holiday parameters.	Google Sheets provides `NETWORKDAYS(start_date, end_date, [holidays])` to return the number of net working days between two dates.	Notion formulas can perform calculations with database properties, built-ins, and functions, but they are designed for database properties rather than traditional spreadsheet cells.	Adobe Acrobat supports calculated PDF form fields such as sum, product, average, minimum, and maximum, rather than spreadsheet-style date functions.
WPS Advantages	Advantage: The function is used directly in spreadsheet cells for date planning and workday analysis. Distinct: It fits a familiar spreadsheet workflow with formula prompts and automatic recalculation.	Compared with WPS: Excel offers established workday functions and similar spreadsheet usage for date calculations.	Compared with WPS: Google Sheets also supports workday calculations, but its documentation notes date-format handling details that users need to check carefully.	Compared with WPS: Notion is better suited to database-property calculations and workflow tracking than cell-based spreadsheet formulas.	Compared with WPS: Acrobat is designed for PDF form calculations instead of spreadsheet date analysis.
Official Source	—	NETWORKDAYS function	NETWORKDAYS	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion: If your main task is counting working days and building date-driven spreadsheet formulas, WPS follows a familiar spreadsheet workflow. Microsoft Excel and Google Sheets provide similar official function coverage, while Notion and Adobe focus on database or PDF form scenarios instead of cell-based spreadsheet calculation.

Use Cases

No.	Scenario	Suitable for	Main challenge	How this feature helps
1	Project duration tracking	Project managers	Need to exclude weekends when measuring actual work time	Use NETWORKDAYS.PLUS to count working days between start and end dates
2	Attendance and leave analysis	HR and admin teams	Need to include holiday exclusions in attendance periods	Add a holiday range to the function parameters
3	Billing and delivery planning	Finance and operations teams	Need to calculate by working days instead of calendar days	Use the result as a billing-cycle or delivery reference
4	Multi-sheet date analysis	Analysts	Date values are stored across different worksheets	Use cross-sheet references in the formula

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic spreadsheet formulas	✅	✅
Basic workday calculation scenarios	✅	✅
Additional advanced office features	Some items may be limited or not included, depending on the plan page	More advanced features and extended benefits are available
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday spreadsheet entry and basic date calculations	Free	It is sufficient for entering and calculating functions such as NETWORKDAYS.PLUS
Frequent office work that also needs more advanced tools or more cloud storage	WPS Premium	Better suited to users who want broader office features and membership benefits

WPS membership center: Subscribe now