ACCRINT Function in Google Sheets: Formula, Examples & Troubleshooting

ACCRINT calculates accrued interest for a security with periodic interest payments. This guide covers a regular first coupon period where settlement is after issue but before the first interest payment. In the example, 60 days of 30/360 accrual at 6% gives 1 per 100 of the stated redemption basis.

Verification: NOT_TESTED_IN_GOOGLE_SHEETS. New results are independently calculated. Google’s published pre-first-payment examples corroborate the accrual model, but one printed formula has inconsistent cell references; that formula is not treated as a working native test.

=ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])

The first three arguments are the issue date, first interest-payment date, and settlement date. rate is annual. Google describes redemption on a per-100 face/par basis; this guide explicitly uses 100. Frequency is 1, 2, or 4 payments per year. Basis is optional and defaults to 0. Codes are 0 US NASD 30/360, 1 Actual/Actual, 2 Actual/360, 3 Actual/365, and 4 European 30/360. Google ACCRINT reference.

The published Google signature has seven positions, including the optional basis. Do not append an additional calculation-mode argument from a different product’s formula. This page does not establish a post-first-payment accrual rule.

Enter this regular semiannual schedule:

In B10 enter:

=ACCRINT(B2,B3,B4,B5,B6,B7,B8)

The expected accrued interest is 1 on the stated 100 basis. Issue to settlement spans 60 convention days, and the arithmetic audit is =100*6%*60/360.

The full regular semiannual coupon would be 3 on the same basis: =100*6%/2. The elapsed part of the 180-day period is one third, giving =3*60/180, again 1. These are two independent ways to check the same simple pre-first-payment model.

Keep the issue and first-payment dates fixed. Enter three settlements in D2:D4 and use =ACCRINT($B$2,$B$3,D2,$B$5,$B$6,$B$7,$B$8) in E2, filling through E4.

Every settlement is strictly before the first payment. The last row deliberately avoids the exact coupon boundary. Do not extend this table beyond July 15 by assuming that interest always accumulates from issue or always resets at each coupon; neither broad rule was established for Google Sheets in this review.

For a hypothetical 10,000 face amount, place 10000 in B12. Since the example’s quote basis is 100, =B10/100*B12 gives 100 of accrued interest at the March settlement. The May settlement scales to 200.

Keep the per-100 quote and the face amount in separate fields. This makes it possible to check a settlement worksheet without confusing a one-unit accrued-interest quote with a one-unit total payment. It does not establish transaction fees, tax treatment, or a broker’s complete settlement amount.

The first-period coupon can provide another audit: =3/100*B12 gives 300. At the March settlement, the independently modeled accrual of 100 is one third of that coupon.

Google’s public table shows issue June 1, 2012, first payment December 31, 2012, settlement August 1, 2012, rate 10%, par 1000, frequency 2, and basis 0, with result 16.66666667. The arithmetic 1000*10%*60/360 agrees. However, its displayed formula points across A2:G2 while the visible input values run down column B, so those printed references are not a reproducible control. A second table shows a different pre-first-payment result, 12.22222222, without a printed formula. Google’s published ACCRINT tables.

These static outputs support the limited numeric model used here. They do not resolve every post-coupon, irregular-period, or reference-coercion question.

Check the order of all three dates before adjusting a formula. Use DATE-created values rather than text whose month/day order could be ambiguous. Verify that 6% is stored as 0.06, and that the frequency reflects the actual coupon schedule.

A different basis can produce a different day fraction. This guide does not provide a complete month-end adjustment algorithm, exact invalid-input error codes, or numerical results for all bases. It also does not establish optional arguments beyond Google’s documented signature.

Google’s contract and pre-first-payment published outputs are the basis for this guide. Matching function names elsewhere are not evidence for additional arguments or matching post-coupon behavior. Introduction and retirement dates were not established.

Related: DATE, DAYS360, and ISNUMBER.

First-party references reviewed October 17, 2026: Google ACCRINT help and the linked public tables above.