Returns the number of days in the coupon period that contains the settlement date.
Syntax
COUPDAYS(settlement, maturity, frequency, [basis])Arguments
settlementrequired
The security's settlement date.
maturityrequired
The security's maturity date.
frequencyrequired
The number of coupon payments per year (1, 2, or 4).
basisoptional
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.