Returns the number of days in the coupon period that contains the settlement date.
Söz dizimi
COUPDAYS(settlement, maturity, frequency, [basis])Bağımsız değişkenler
settlementzorunlu
The security's settlement date.
maturityzorunlu
The security's maturity date.
frequencyzorunlu
The number of coupon payments per year (1, 2, or 4).
basisisteğe bağlı
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.