COUPNUM
Category: Financial Function.
Description: Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
Syntax: COUPNUM(settlement, maturity, frequency, [basis])
The COUPNUM function syntax has the following arguments:
Settlement: security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
Maturity: security's maturity date. The maturity date is the date when security expires.
Frequency: number of coupon payments per year. Annual payments, frequency = 1; for semiannual, frequency = 2; for quaterly, frequency = 4.
Basis: type of day count basis to use.