COUPDAYS function in Excel
Returns the number of days in the coupon period that contains the settlement date
=COUPDAYS(settlement, maturity, frequency, [basis])COUPDAYS syntax and parameters
Four arguments, three required.
- settlementanyRequired
The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
- maturityanyRequired
The security's maturity date. The maturity date is the date when the security expires.
- frequencynumberRequired
The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.
- basisanyOptional
The type of day count basis to use.
COUPDAYS examples
Formulas you'll actually reuse.
Days in the coupon period containing settlement — 180 on a 30/360 basis:
=COUPDAYS(DATE(2026, 5, 15), DATE(2031, 3, 15), 2, 0)Result
180The same on actual/actual (1) — the real count from Mar 15 to Sep 15:
=COUPDAYS(DATE(2026, 5, 15), DATE(2031, 3, 15), 2, 1)Result
184
COUPDAYS in Google Sheets
Same name — your formula ports as-is.
Try COUPDAYS in the playground
Edit the example — nothing to install.
Preloaded with the COUPDAYS formula from Example 1 — change anything and watch it respond.
Related functions
More ways Excel gets this done.
- ACCRINTReturns the accrued interest for a security that pays periodic interestFinancialGoogle Sheets
- ACCRINTMReturns the accrued interest for a security that pays interest at maturityFinancialGoogle Sheets
- AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficientFinancialNo Google Sheets equivalent
- AMORLINCReturns the depreciation for each accounting periodFinancialGoogle Sheets
- COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement dateFinancialGoogle Sheets
- COUPDAYSNCReturns the number of days from the settlement date to the next coupon dateFinancialGoogle Sheets