COUPNUM(settlement,maturity,frequency[,basis,eom])
COUPNUM returns the numbers of coupons to be paid between the settlement and maturity dates, rounded up.
settlement is the settlement date of the security.
maturity is the maturity date of the security.
frequency is the number of coupon payments per year.
eom = TRUE handles end of month maturity dates special.
Allowed frequencies are: 1 = annual, 2 = semi, 4 = quarterly. 6 = bimonthly, 12 = monthly.
basis is the type of day counting system you want to use:
0 MSRB 30/360 (MSRB Rule G33 (e))
1 actual days/actual days
2 actual days/360
3 actual days/365
4 European 30/360
5 European+ 30/360
COUPNUM (DATE(2002,11,29),DATE(2004,2,29),4,0) = 6
COUPNUM (DATE(2002,11,29),DATE(2004,2,29),4,0,FALSE) = 5