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.