Returns the number of days in the coupon period that contains the settlement date.
구문
COUPDAYS(settlement, maturity, frequency, [basis])인수
settlement필수
The security's settlement date.
maturity필수
The security's maturity date.
frequency필수
The number of coupon payments per year (1, 2, or 4).
basis선택
The type of day count basis to use (0-4).
This function calculates the total number of days in the coupon period that includes the settlement date. It is commonly used to determine the duration of a coupon period for financial securities.
=COUPDAYS("2023-01-25", "2024-11-15", 2, 1)→182Calculates the days in the coupon period for a bond with semi-annual payments using the actual/365 basis.
Input dates
Ensure your settlement and maturity dates are entered in a format Excel recognizes as a date.
Define frequency
Specify the coupon frequency as 1 for annual, 2 for semi-annual, or 4 for quarterly.
It determines how the day count is calculated, with 0 being US (NASD) 30/360 and 1 being actual/actual.