Back to Class Index
COUPDAYS(S, M, F, [B])This function returns the number of days in the coupon period that the settlement date is in. Parameters S The settlement date M The maturity date F The number of coupon payments per year (frequency) B (Optional) The day count basis to be used: 0 or omitted 30/360 1 Actual/actual 2 Actual/360 3 Actual/365 Examples COUPDAYS(DATE(93, 2, 15), DATE(94, 12, 20), 2, 0) = 180 COUPDAYS(DATE(93, 2, 15), DATE(94, 12, 20), 2, 1) = 182 |