ACCRINT

Accrued interest for a security paying periodic interest.

Excel: Not checked yet
Google Sheets: Not checked yet
Returns: Number

Examples

=ACCRINT(DATE(2025,3,1), DATE(2025,9,1), DATE(2026,1,15), 0.05, 1000, 2)

Result 43.611111111111114

Syntax

ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])

issue: number required
first_interest: number required
settlement: number required
rate: number required
par: number required
frequency: number required
basis: number optional
calc_method: boolean optional

Errors

#NUM!: =ACCRINT(2, 2, 2, 0.05, 2, 2)

ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement. COUPDAYSNCDays from settlement to the next coupon date.