COUPDAYSNC(settlement,maturity,frequency[,basis,eom])
COUPDAYSNC returns the number of days from the settlement date to the next coupon date.
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
(See the gnumeric manual for a detailed description of these bases).
COUPDAYSNC (DATE(2002,11,29),DATE(2004,2,29),4,0) = 1
COUPDAYSNC (DATE(2002,11,29),DATE(2004,2,29),4,0,FALSE) = 89