ACCRINT in WPS on Windows: Introduction

ACCRINT in WPS on Windows is a spreadsheet function for accrued interest calculations on securities with periodic payments; 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

ACCRINT in WPS Spreadsheet on Windows is a financial function used to calculate the accrued interest of a security that pays periodic interest.

Core tasks include:

Enter ACCRINT( and review the syntax prompt to confirm the argument order.
Complete the formula with issue date, first interest date, settlement date, rate, par value, and payment frequency.
Reference cells in the same worksheet or across worksheets to reuse existing data.
Update results automatically when referenced values change in a financial worksheet.

This function is useful for bond interest calculations, fixed-income analysis, finance training, and spreadsheet-based security models.

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 network connection is required for local formula calculation; downloading, installation, and account services require internet access
Other	You need access to WPS Spreadsheet and editable cells, with valid date and numeric data prepared

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, launch Spreadsheet, and enter `=ACCRINT(` in a cell to confirm the formula input environment is available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	ACCRINT can be entered directly in WPS Spreadsheet with syntax prompts, argument input, cross-sheet references, and recalculation when source values change.	Excel provides the ACCRINT function to return the accrued interest for a security that pays periodic interest, with documented syntax, arguments, and error conditions.	Google Sheets provides the ACCRINT function to calculate the accrued interest of a security with periodic payments, including date and day-count convention arguments.	Notion provides database formula syntax and functions, but it is not a spreadsheet financial-function system and does not provide a dedicated ACCRINT function for security interest calculations.	Adobe Acrobat provides calculation options for PDF form fields, such as sums and products, but it does not provide spreadsheet financial functions like ACCRINT.
WPS Advantages	Advantage: ACCRINT can be used directly in a spreadsheet workflow with cell references and recalculation, which fits ongoing table-based finance work.	Compared with WPS: Excel also provides the same named function with detailed argument guidance, so the function scope is similar.	Compared with WPS: Google Sheets also provides ACCRINT, with its own help structure and argument naming.	Compared with WPS: Notion formulas are better suited to database properties than standard accrued-interest spreadsheet functions.	Compared with WPS: Acrobat is suited to PDF form calculations rather than spreadsheet-based financial modeling.
Official Source	—	ACCRINT function	ACCRINT	Formula syntax and functions	Configure form field calculations in Acrobat

Overall Conclusion
For spreadsheet-based accrued interest calculations, WPS, Microsoft Excel, and Google Sheets all provide a direct ACCRINT function path. Notion and Adobe focus on database formulas or PDF form calculations, so their use cases differ from spreadsheet financial modeling.

Use Cases

No.	Scenario	Suitable for	Main challenge	How ACCRINT helps
1	Bond accrued interest calculation	Finance staff	Need to calculate accrued interest before settlement quickly	Use ACCRINT with dates, rate, and frequency arguments
2	Finance training and teaching	Teachers and students	Need to explain financial function structure clearly	Enter `=ACCRINT(` to show syntax prompts and argument order
3	Reusable security analysis templates	Analysts	Re-entering security data repeatedly takes time	Reuse issue date, settlement date, and par value through cell references
4	Dynamic financial models	Spreadsheet users	Manual recalculation after data changes is inefficient	Let recalculation update the result when referenced values change
5	Cross-sheet data organization	Team collaborators	Input values are spread across multiple worksheets	Reference cells across worksheets and keep one calculation formula

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
ACCRINT formula entry and calculation	✅	✅
Basic spreadsheet editing	✅	✅
Additional advanced benefits and value-added services	Depends on the current account benefits shown	Includes more advanced benefits and value-added services

Source: WPS Office pricing page

Recommendations

Use case	Recommended plan	Why
Daily formula learning and basic calculations	Free	The ACCRINT function itself is available for regular spreadsheet calculations
Broader office needs with more advanced benefits	WPS Premium	Suitable if you also need additional value-added services and broader office features

WPS membership center: Subscribe now