DAYS360 in WPS on Windows: Introduction

DAYS360 in WPS on Windows calculates the number of days between two dates using a 360-day year rule; 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	All current tasks are available directly

About This Feature

Overview

The DAYS360 function in WPS is used in multidimensional tables to calculate the number of days between two dates based on a 360-day year with 30-day months. It is suitable for finance, settlement cycles, and fixed-period tracking.

Core capabilities include:

Use DAYS360 in a formula field to calculate date intervals.
Open the function entry in the formula editor and fill in parameters in the required format.
Combine DAYS360 with other functions for more complete business logic.

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 for a stable multidimensional table and formula editing experience
Network	A network connection is recommended when opening online multidimensional tables, syncing data, or viewing function guidance
Other	You need access to open the multidimensional table and permission to add or edit formula fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Start WPS Office, open a multidimensional table, and confirm that entries related to Add Field and Formula are available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Use DAYS360 in a formula field inside a multidimensional table to calculate date differences with a 360-day convention and combine it with other functions.	Excel provides the DAYS360 function to return the number of days between two dates based on a 360-day year and supports an optional method argument.	Google Sheets provides the DAYS360 function with start date, end date, and an optional method argument.	Notion database formulas support date calculations such as dateBetween, but do not provide a spreadsheet-style DAYS360 function with the same name.	Acrobat focuses on calculated PDF form fields and expressions rather than spreadsheet-style DAYS360 functions.
WPS Advantages	Advantage: DAYS360 can be placed directly in a multidimensional table field and recalculated with each record update. Distinct: it fits workflows where date logic is managed as part of the table structure.	Compared with WPS: Excel offers the same named function in a worksheet cell formula model that fits spreadsheet-based workbooks.	Compared with WPS: Google Sheets also offers the same named function, mainly in an online spreadsheet cell formula model.	Compared with WPS: Notion is better aligned with database property formulas, and date differences can be built, but the formula model is different from spreadsheet functions.	Compared with WPS: Adobe centers on PDF form calculations rather than multidimensional table or spreadsheet function workflows.
Official Source	—	Excel DAYS360 function	Google Sheets DAYS360	Notion database formula guide	Acrobat PDF form calculations

Overall Conclusion
If your work is centered on record-based multidimensional tables and field-level automation, WPS DAYS360 fits that structure well. If you mainly build models in traditional spreadsheet cells, Excel and Google Sheets also provide the same named function, while Notion and Adobe are only partial alternatives for this use case.

Use Cases

No.	Scenario	Suitable For	Core Need	Solution
1	Financial interest period calculation	Finance teams, cashiers	A consistent 360-day convention is needed for period calculations	Use DAYS360 in a formula field to calculate the difference between start and end dates
2	Contract billing cycle tracking	Operations teams, sales support	Contract cycle calculations need a consistent rule	Use DAYS360 to generate standardized billing-cycle results
3	Project cycle dashboards	Project managers	Cycle length needs to appear automatically at the record level	Add DAYS360 to a formula field and let it refresh with data updates
4	Validation helper columns	Data analysts	Manual date-difference checks are inefficient	Output results automatically through a formula field for filtering and comparison
5	Combined formula logic	Advanced users	A date difference also needs to be used in conditions	Combine DAYS360 with functions such as IF and AND

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Use the DAYS360 function	✅ Available	✅ Available
Basic multidimensional table formulas	✅ Available	✅ Available
More PDF tools, advanced templates, and extended benefits	Some features are limited	More extended benefits are available
Cloud storage and added services	Basic allocation	Higher allocation or more services

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
You only need DAYS360 and basic formula work in multidimensional tables	Free	The current function usage does not require membership and fits everyday calculations
You also need more templates, PDF tools, or more cloud storage	WPS Premium	Suitable if you also use broader office features beyond this function

WPS membership center: Subscribe now