ACCRINT Function in Excel: Interest Earned Since Last Coupon

⏱ 1 min readUpdated 28 September 2026

FinancialLevel: ExpertAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Related functions

ACCRINT calculates interest that has built up on a bond — the amount a buyer pays the seller on top of the quoted price.

Syntax

=ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])
Argument What it means
par Face value.

Examples

Example 1

=ACCRINT(DATE(2019,5,1), DATE(2019,11,1), DATE(2019,8,1), 7%, 100000, 2)

About ₹1,750 accrued for three months.

PRICE · YIELD

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZCOUNTBLANK Function in Excel: Count Empty CellsExcel Functions A–ZPPMT Function in Excel: Principal Part of an EMIExcel Functions A–ZDMAX Function in Excel: Largest Value With a Criteria Table
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong