WorksheetFunction.CoupDaysNc (Excel)

Returns the number of days from the settlement date to the next coupon date.

CoupDaysNc (Arg1, Arg2, ..., Arg4)

Dim dblCoupDaysNc As Double
dblCoupDaysNc = WorksheetFunction.CoupDaysNc(Arg1:=, Arg2:=, Arg3:=)

Arguments

Arg1 - The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer

Arg2 - The security's maturity date. The maturity date is the date when the security expires

Arg3 - The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4

Arg4 - The type of day count basis to use