Excel Function : COUPDAYS

Download now!

Excel Function : COUPDAYS

Category

Financial

Description

Returns the number of days in the coupon period that contains the settlement date

Microsoft Excel Reference Page

https://support.office.com/en-us/article/COUPDAYS-function-cc64380b-315b-4e7b-950c-b30b0a76f671

Syntax and Description of the COUPDAYS Excel Function

In Excel, the COUPDAYS function returns the number of days between the settlement date and the next coupon date. The syntax for the COUPDAYS function is: = COUPDAYS (settlement, maturity, frequency, [basis]) where: settlement - the settlement date of the security. maturity - the maturity date of the security. frequency - the number of coupons per year. basis - [optional] the type of day count basis to use. The basis argument can be one of the following values: 0 or omitted - US (NASD) 30/360 1 - Actual/

About COUPDAYS Excel Function

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