Home › Functions › Financial › COUPDAYS
fx
COUPDAYS
Financial  ·  Since: Excel 2003  ·  9 languages

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

🌐 Translations

English COUPDAYS
Deutsch ZINSTERMTAGE
Français NB.JOURS.COUPONS
Español CUPON.DIAS
Italiano GIORNI.CED
Português CUPDIAS
Nederlands COUP.DAGEN
Polski WYPŁ.DNI
Русский ДНЕЙКУПОН

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

COUPDAYS(settlement,maturity,frequency,[basis])

Arguments

settlement (required) — The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
maturity (required) — The security's maturity date. The maturity date is the date when the security expires.
frequency (required) — The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.
basis (optional) — The type of day count basis to use.

▶ Examples

=COUPDAYS(A2,A3,A4,A5)

Related functions

Copied to clipboard