Excel

ACCRINT function in Excel

Returns the accrued interest for a security that pays periodic interest

=ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])

ACCRINT syntax and parameters

Eight arguments, six required.

issueanyRequired
The security's issue date.
first_interestanyRequired
The security's first interest date.
settlementanyRequired
The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
ratenumberRequired
The security's annual coupon rate.
parnumberRequired
The security's par value. If you omit par, ACCRINT uses $1,000.
frequencynumberRequired
The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.
basisanyOptional
The type of day count basis to use.
calc_methodbooleanOptional
A logical value that specifies the way to calculate the total accrued interest when the date of settlement is later than the date of first_interest. A value of TRUE (1) returns the total accrued interest from issue to settlement. A value of FALSE (0) returns the accrued interest from first_interest to settlement. If you do not enter the argument, it defaults to TRUE.

Formulas you'll actually reuse.

Interest accrued on a $1,000 bond two months into its first semi-annual period:
```
=ACCRINT(DATE(2026, 3, 15), DATE(2026, 9, 15), DATE(2026, 5, 15), 5%, 1000, 2, 0)
```
Result8.3333
The same from cells, on an actual/actual basis (1) — what the buyer owes the seller on top of the clean price:
```
=ACCRINT(B2, C2, D2, E2, F2, 2, 1)
```

Same name — your formula ports as-is.

Edit the example — nothing to install.

Preloaded with the ACCRINT formula from Example 1 — change anything and watch it respond.

Loading the editor…

What they mean — and the fixes.

More ways Excel gets this done.