Formulas > =ACCRINT()

How To Use ACCRINT() Function in Google Sheets


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

Common questions about the ACCRINT formula in Google Sheets include:
What does the ACCRINT formula do?
How do I use the ACCRINT formula in Google Sheets?
What are the required arguments of the ACCRINT formula?
Can the ACCRINT formula handle different day count conventions?
How does the ACCRINT formula handle leap years?
Are there any limitations or restrictions when using the ACCRINT formula?
How can I interpret and use the result of the ACCRINT formula?

The ACCRINT formula in Google Sheets is used to calculate the accrued interest for a security that pays periodic interest. It takes into account the specified issue date, settlement date, annual coupon rate, and redemption value. This formula is commonly used in financial analysis and bond calculations.

To use the ACCRINT formula appropriately, follow these steps:
Provide the required arguments: issue date, settlement date, annual coupon rate, redemption value, and frequency.
Make sure the dates are formatted correctly and entered as valid date values.
Use the appropriate date system (either 1900 or 1904) based on your spreadsheet settings.
Specify the frequency of interest payments (e.g., semi-annual, quarterly) to match the bond's terms.
Press Enter to calculate the accrued interest.

The ACCRINT formula can be mistyped in several ways. Here are a few common mistakes:
Misspelling the formula as "ACCRINTS" or "ACCRNIT."
Omitting the required arguments or using incorrect argument syntax.
Mixing up the order of the arguments.
Using invalid or incompatible data types in the formula.

The ACCRINT formula can be used inappropriately in a few common ways:
Applying the formula to securities or scenarios that do not involve periodic interest payments.
Using the formula with inconsistent or incorrect date formats.
Not adjusting the annual coupon rate or redemption value to match the specified frequency.

When using the ACCRINT formula, there are some common pitfalls to watch out for:
Ensuring the issue date and settlement date are within a valid range and do not create negative time periods.
Verifying that the annual coupon rate and redemption value are accurate and correspond to the bond being analyzed.
Considering the appropriate day count convention based on the market and bond terms.

Common mistakes when using the ACCRINT formula include:
Forgetting to format the dates correctly, leading to incorrect results or errors.
Using a wrong or inconsistent frequency value, resulting in inaccurate calculations.
Failing to adjust for leap years when necessary, which can affect the accrued interest.

Common misconceptions people might have about the ACCRINT formula:
Believing that the formula automatically adjusts for different day count conventions without specifying the appropriate convention.
Assuming that the formula can calculate the total value of a bond or security, including the principal amount.
Expecting the formula to automatically account for accrued interest on a specific date without specifying the settlement date.

It's important to have a good understanding of the ACCRINT formula, its required arguments, and its limitations to avoid these common pitfalls and misconceptions.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

There are no shortcuts to becoming a Google Sheets pro! Learn more here at Better Sheets

Watch the magic for yourself. Video tutorials at every turn here at Better Sheets.

Your spreadsheets will never be the same again.

How To Actually Use ACCRINT() in Sheets

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

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the ACCRINT() formula:

Generate a ACCRINT() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.