ACCRINTM
Financial

Returns the accrued interest for a security that pays interest at maturity

Syntax:

=ACCRINTM(issue, settlement, rate, par, [basis])

Example:

=ACCRINTM("1/1/2023", "12/31/2023", 0.1, 1000)