WorksheetFunction.AccrInt method (Excel)

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

Syntax

expression.AccrInt (Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7)

expression A variable that represents a WorksheetFunction object.

Parameters

Name	Required/Optional	Data type	Description
Arg1	Required	Variant	Issue date - Security's issue date.
Arg2	Required	Variant	First interest - Security's first interest date.
Arg3	Required	Variant	Settlement - Security's settlement date
Arg4	Required	Variant	Rate - Security's annual coupon rate.
Arg5	Required	Variant	Par - Security's par value.
Arg6	Required	Variant	Frequency - Number of coupon payments per year.
Arg7	Optional	Variant	Basis - The type of day count basis to use.

Return value

Double

Remarks

Important

Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

The following table describes the values that can be used for Arg7.

Basis	Day count basis
0 or omitted	US (NASD) 30/360
1	Actual/actual
2	Actual/360
3	Actual/365
4	European 30/360

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.