Formulas > =ACCRINT()
How to Use ACCRINT() in Google Sheets
Description
How To Actually Use ACCRINT() in Sheets
ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])
Try ACCRINT yourself
Use the ACCRINT formula to calculate the accrued interest for the security data in cells A1:F1. The correct answer must return the accrued interest amount.
Hints (2)
-
Make sure to reference the correct cells for each argument.
-
Remember that the first payment date and settlement date are important for the calculation.
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 BetterSheets.co/formulas
Learn more about the ACCRINT() formula:
Generate a ACCRINT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses ACCRINT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a ACCRINT() formula