Skip to content
Google Sheets

ACCRINT function in Google Sheets

Calculates the accrued interest of a security that has periodic payments.

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

ACCRINT syntax and parameters

Seven arguments, six required.

  • issueanyRequired

    The date the security was initially issued.

  • first_paymentanyRequired

    The first date interest will be paid.

  • settlementanyRequired

    The settlement date of the security, the date after issuance when the security is delivered to the buyer. settlement is the maturity date of the security if it is held until maturity rather than sold.

  • ratenumberRequired

    The annualized rate of interest.

  • redemptionnumberRequired

    The redemption amount per 100 face value, or par.

  • frequencynumberRequired

    The number of interest or coupon payments per year (1, 2, or 4).

  • day_count_conventionnumberOptional

    [ OPTIONAL - 0 by default ] - An indicator of what day count method to use. 0 indicates US (NASD) 30/360 - This assumes 30 day months and 360 day years as per the National Association of Securities Dealers standard, and performs specific adjustments to entered dates which fall at the end of months. 1 indicates Actual/Actual - This calculates based upon the actual number of days between the specified dates, and the actual number of days in the intervening years. Used for US Treasury Bonds and Bills, but also the most relevant for non-financial use. 2 indicates Actual/360 - This calculates based on the actual number of days between the speficied dates, but assumes a 360 day year. 3 indicates Actual/365 - This calculates based on the actual number of days between the specified dates, but assumes a 365 day year. 4 indicates European 30/360 - Similar to 0, this calculates based on a 30 day month and 360 day year, but adjusts end-of-month dates according to European financial conventions.

ACCRINT examples

Formulas you'll actually reuse.

  1. 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

  2. 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)

ACCRINT in Excel

Same name — your formula ports as-is.

Try ACCRINT in the playground

Edit the example — nothing to install.

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

Loading the editor…

ACCRINT errors

What they mean — and the fixes.

  • #NUM!

    issue is on or after settlement, or rate or par is zero or negative.

Related functions

More ways Google Sheets gets this done.