Formulas > =ACCRINTM()

How To Use ACCRINTM() Function in Google Sheets


Calculates the accrued interest of a security that pays interest at maturity.

The ACCRINTM formula in Google Sheets calculates the accrued interest of a security that pays periodic interest. Here are some common questions and issues related to this formula:

What does the ACCRINTM formula do?
The ACCRINTM formula figures out the accrued interest of a security that pays periodic interest.

How can the ACCRINTM formula be used appropriately?
To use the ACCRINTM formula appropriately, you should provide the correct arguments in the formula. These arguments include the issue date, settlement date, annual coupon rate, and par value of the security.

How can the ACCRINTM formula be commonly mistyped?
The ACCRINTM formula can be mistyped as ACRINTM, or ACRITM, or ACCRRINTM, or CRINTM, or CRRINTM.

What are some common ways the ACCRINTM formula is used inappropriately?
Some common ways the ACCRINTM formula is used inappropriately include using it for securities that don't pay periodic interest or using incorrect arguments in the formula.

What are some common pitfalls when using the ACCRINTM formula?
One common pitfall when using the ACCRINTM formula is providing the wrong dates or rate, which can result in incorrect accrued interest calculations.

What are common mistakes when using the ACCRINTM Formula?
Common mistakes when using the ACCRINTM formula include not accounting for leap years, using the wrong day count convention, or providing incorrect values for the arguments.

What are common misconceptions people might have with the ACCRINTM Formula?
One common misconception about the ACCRINTM formula is that it calculates the total return of a security, which is not true. The formula only calculates the accrued interest, not the capital gains or losses of the security.

The ACCRINTM formula is only as good as your data is good. If your data is bad then the calculation made will be bad, or incorrect. Messy data creates messy sheets.

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.

Looking for a way to segment data based on specific criteria? The FILTER formula is perfect for you. 

If you need to replace VLOOKUP, give INDEX/MATCH a try.

At, I have everything you need to take your Google Sheets skills to the next level. 
From ARRAYFORMULA() to ZTEST(), Better Sheets has it all. 

There’s 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 ACCRINTM() in Sheets

ACCRINTM(issue, maturity, rate, [redemption], [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 ACCRINTM() formula:

Generate a ACCRINTM() 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.