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

File:Calci1.gif

---