Quick Navigation
COUPDAYS Function
Summary
The COUPDAYS function in Excel calculates the number of days in the coupon period containing the settlement date for bonds or securities. Essential for financial analysis, it helps determine accrued interest periods based on specified day count conventions.
Syntax
COUPDAYS(settlement, maturity, frequency, [basis])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| settlement | Date |
Yes | Security's settlement date - date after issue when traded to buyer |
| maturity | Date |
Yes | Security's maturity date - when the security expires |
| frequency | Number |
Yes | Coupon payments per year (1=annual, 2=semiannual, 4=quarterly) |
| basis | Number |
No | Day count basis (0=US 30/360, 1=Actual/actual, 2=Actual/360, 3=Actual/365, 4=European 30/360) |
Using the COUPDAYS Function
COUPDAYS is vital for fixed income analysis, calculating the exact days in the current coupon period for accurate accrued interest computation in bond trading and portfolio management.
Common COUPDAYS Examples
Semiannual Bond Coupon Period
=COUPDAYS(DATE(2011,1,25),DATE(2011,11,15),2,1)Calculates days in coupon period for semiannual bond with actual/actual basis: returns 181
Quarterly Coupon with US Basis
=COUPDAYS("1/15/2024","6/30/2024",4,0)Returns days in quarterly coupon period using US (NASD) 30/360 convention
Annual Payment European Basis
=COUPDAYS(DATE(2023,3,1),DATE(2025,3,1),1,4)Calculates annual coupon period days using European 30/360 method
Frequently Asked Questions
Common Errors and Solutions
#VALUE!
Cause: Settlement or maturity not valid dates
Solution: Use DATE() function: DATE(2024,1,15)
#NUM!
Cause: Frequency not 1, 2, or 4; basis <0 or >4; settlement >= maturity
Solution: Verify frequency (1/2/4) and basis (0-4); ensure settlement < maturity
#VALUE!
Cause: Dates entered as text
Solution: Convert to proper dates using DATE function
Notes
- Excel stores dates as serial numbers (Jan 1, 1900 = 1)
- All arguments truncated to integers
- Use with COUPDAYSNC for days from settlement to next coupon
- Part of Excel's financial coupon functions family
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365
Not available in: Excel 2003, Earlier versions
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+