ACCRINTM Function
Returns accrued interest on a security that pays all its interest at maturity.
Category
Financial
Available in
All versions, Microsoft 365
Returns
Accrued interest
Want to practice ACCRINTM in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
Some short-term securities pay no coupons — all the interest comes at maturity. ACCRINTM returns the interest accrued from issue to a date.
It's par × rate × the fraction of a year between the two dates.
Syntax
=ACCRINTM(issue, settlement, rate, par, [basis])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| issue | Yes | The date the security was first issued. |
| settlement | Yes | The date to accrue to (often maturity). |
| rate | Yes | The annual coupon rate. |
| par | Yes | The face value. |
| basis | No | Day count: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360. |
Examples
Example 1 — Interest on a six-month note
A $50,000 note issued 1/10/2026 at 4.5%, paying everything on 7/10/2026.
B2fx=ACCRINTM(DATE(2026,1,10),DATE(2026,7,10),4.5%,50000,3)
| A | B | |
|---|---|---|
| 1 | Basis | Interest |
| 2 | 3 (actual/365) | 1,115.75 |
| 3 | 0 (30/360) | 1,125.00 |
The day-count basis changes the answer: 181 actual days vs exactly half a 360-day year.
Common mistakes
- #VALUE! or #NUM!. A date isn't a real date, settlement is on or after maturity, or frequency isn't 1, 2 or 4.
Notes
- Enter dates with DATE or as cells holding real dates. Text dates like "3/15/2026" typed straight into the formula can be misread on computers with other regional settings.
- Related functions: ACCRINT, YIELDMAT, PRICEMAT.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.