WorksheetFunction.AccrInt (Excel)

Returns the accrued interest for a security that pays periodic interest.

AccrInt (Arg1, Arg2, ..., Arg7)

Dim dblAccrInt As Double
dblAccrInt = WorksheetFunction.AccrInt(Arg1:=, Arg2:=, Arg3:=, Arg4:=, Arg5:=, Arg6:=)

Arguments

Arg1 - Issue date - Security's issue date

Arg2 - First interest - Security's first interest date

Arg3 - Settlement - Security's settlement date

Arg4 - Rate - Security's annual coupon rate

Arg5 - Par - Security's par value

Arg6 - Frequency - Number of coupon payments per year

Arg7 - Basis - The type of day count basis to use