COUPNUM function


Calculates the number of coupons payable between the settlement date and the maturity date, and rounds the result to the nearest whole coupon.



COUPNUM( settlementmaturityfrequency, [basis] )


required arguments:

settlement The security settlement date is the date after the issue date when the security is traded to the buyer.
maturity The maturity date is the date when the security expires.
frequency For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.


optional arguments:

[basis] The type of day count basis to use.