ACCRINT in WPS on Windows: Introduction

WPS ACCRINT is an accrued interest function in Spreadsheets for calculating the accrued interest of a security with periodic payments; it includes 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

ACCRINT is a built-in financial function in WPS Spreadsheets on Windows for calculating the accrued interest of a security that pays periodic interest. After you enter the function, you can combine dates, rate, par value, and payment frequency to return a result directly in a worksheet cell.

Core capabilities include:

Use the ACCRINT function quickly for worksheet-based financial calculations and analysis.
Enter flexible parameters for different security terms and calculation needs.
Work with cross-sheet references and nested formulas in larger worksheet models.
Recalculate results automatically when referenced 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 mandatory internet connection is required for local formula calculation; internet access is needed for download, installation, and account services
Other	You need to open a spreadsheet file and have permission to edit worksheet formulas

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Download WPS Office for Windows and complete the setup with the installation wizard
Check after installation	Open WPS Spreadsheets, create or open a workbook, and type `=ACCRINT(` in a cell to check whether the function prompt appears

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Use the ACCRINT function directly in spreadsheet cells with parameter prompts, cross-sheet references, nested formulas, and automatic recalculation when data changes.	Excel provides the ACCRINT function to return the accrued interest for a security that pays periodic interest, with syntax, arguments, remarks, and error details.	Google Sheets provides the ACCRINT function to calculate the accrued interest of a security with periodic payments, including date, frequency, and day-count inputs.	Notion provides database formula syntax, property references, and general functions, but it does not provide a spreadsheet-style ACCRINT function for fixed-income calculations.	Adobe Acrobat provides calculated PDF form fields such as sum, product, average, minimum, and maximum, rather than spreadsheet financial functions like ACCRINT.
WPS Advantages	Advantage: ACCRINT works directly in worksheet cells for spreadsheet-based financial analysis. Distinct: It fits naturally with existing cell references, cross-sheet data, and nested worksheet formulas.	Compared with WPS: Excel also provides a dedicated ACCRINT function and detailed function documentation; both are suitable for spreadsheet financial calculations.	Compared with WPS: Google Sheets also supports ACCRINT, but it is centered on an online spreadsheet workflow; WPS fits local desktop spreadsheet editing well.	Compared with WPS: Notion formulas are designed for database properties and general logic, so they are not a direct match for spreadsheet ACCRINT formulas.	Compared with WPS: Adobe calculation features are designed for PDF form fields, so they are not a direct fit for worksheet-based ACCRINT analysis.
Official Source	—	ACCRINT function	ACCRINT	Formula syntax and functions	Configure form field calculations in Acrobat

Overall Conclusion
ACCRINT in WPS is well suited to worksheet-based accrued interest calculations that depend on cell references, cross-sheet data, and nested formulas. If your work centers on spreadsheet financial functions, WPS, Excel, and Google Sheets all provide relevant support, while Notion and Adobe focus on different calculation environments.

Use Cases

No.	Scenario	Suitable for	Main challenge	How it helps
1	Bond accrued interest estimation	Finance staff	You need to calculate accrued interest on a settlement date quickly	Enter ACCRINT in a cell and fill in dates, rate, par value, and frequency
2	Linked investment models	Investment analysts	Interest results need to update across multiple worksheets	Use cross-sheet references so ACCRINT updates with related worksheet data
3	Reusable financial templates	Spreadsheet maintainers	Re-entering formulas repeatedly takes time	Preset ACCRINT in a template and replace only the input values later
4	Result review and recalculation	Data analysts	Results need to be recalculated after source data changes	Use automatic recalculation to review updated results immediately
5	Formula learning and troubleshooting	New users	Function arguments and input order are not yet familiar	Follow the function prompt and verify the result in the worksheet cell

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
ACCRINT function calculation	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Cloud storage	1 GB	20 GB
Template resources	Basic templates	More template resources
Some advanced services	Provided as described on the product page	More benefits provided as described on the product page

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Daily formula learning and basic spreadsheet calculation	Free	The ACCRINT function itself is available for direct use in routine calculation and practice
More cloud storage and extended services	WPS Premium	Suitable if you also need more cloud storage, templates, and additional office services

WPS membership center: Subscribe now