next up previous contents index
Next: COUPDAYSNC Up: A. Function Reference Previous: COUPDAYBS   Contents   Index


COUPDAYS

Syntax: COUPDAYS(S, M, F, [B])

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

COUPDAYS returns the number of days in the coupon period that the settlement date is in.

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

Excel function: N/A


next up previous contents index
Next: COUPDAYSNC Up: A. Function Reference Previous: COUPDAYBS   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003