COUPDAYS function in excel is a financial function. It is used to retrieve number of days in the coupon period including the settlement date. It is a worksheet function and can be entered into the cell in which value is required.


=COUPDAYS(Settlement, Maturity, Frequency, basis)


Settlement:  It is the settlement date of the security.

Maturity:  It is the maturity date of the security.

Frequency: Number of coupon payments per year.

Basis: It is the day count basis to be used. Default value is 0.



In this example, various arguments are entered in column A and their values are entered in column B and COUPDAYS function is used to retrieve the result in column D.

Leave a Reply

Your email address will not be published. Required fields are marked *