Manuals/calci/COUPDAYS
COUPDAYS(settle, M, F, basis) Where 'settle' is the security's settlement date,
'M' is the security's maturity date,
'F' is the number of coupon payments per year and
'basis' is the type of day count basis to use.
This function calculates the number of days in the
coupon period that contains the settlement date.
- COUPDAYS shows the error value when 'settle'
- or 'M' is not a valid date or
- settlement ≥ maturity
- 'F' value should be 1,2 or 4 and
- 'basis' is between 0 and 4.
- Otherwise it shows error.
- If settlement ≥ maturity,
- COUPDAYS returns the #NUM! error value.
COUPDAYS
Lets see an example, COUPDAYS(settle, M, F, basis) B 06-20-2009 12-10-2010 2 1 =COUPDAYS(B2,B3,B4,B5)is 183
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 06-20-2009 | |||
| Row2 | 12-10-2010 | |||
| Row3 | 2 | |||
| Row4 | 1 | |||
| Row5 | 183 | |||
| Row6 |
