ACCRINT
Syntax
=ACCRINT(issue; first_interest; settlement; rate; par; frequency; [basis]; [calc_method])
Description
Returns the accrued interest for a security that pays periodic interest.