Quick Navigation
COUPDAYSNC Function
Summary
The COUPDAYSNC function calculates the number of days from the bond's settlement date to its next coupon payment date, essential for precise interest calculations in fixed-income securities analysis.
Syntax
COUPDAYSNC(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 security expires) |
| frequency | Number |
Yes | Coupon payments per year (1=annual, 2=semiannual, 4=quarterly) |
| basis | Number |
No | Day count basis (0=30/360 US, 1=Actual/actual, 2=Actual/360, 3=Actual/365, 4=30/360 European) |
Using the COUPDAYSNC Function
COUPDAYSNC is crucial for bond traders and analysts who need to calculate accrued interest and clean prices. It determines the exact number of days from settlement to the next coupon date using the specified day count convention.
Common COUPDAYSNC Examples
Semiannual Bond Next Coupon Days
=COUPDAYSNC(DATE(2011,1,25),DATE(2011,11,15),2,1)Returns 110 days from Jan 25, 2011 settlement to next semiannual coupon using actual/actual basis
Quarterly Coupon Calculation
=COUPDAYSNC("1/15/2024","12/31/2024",4,0)Calculates days to next quarterly coupon using US 30/360 convention
Annual Bond Example
=COUPDAYSNC(DATE(2023,6,1),DATE(2033,6,1),1,4)Days to next annual coupon using European 30/360 method
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Settlement or maturity not valid dates
Solution: Use DATE() function: DATE(2024,1,15)
#NUM! error
Cause: Invalid frequency (not 1,2,4) or basis (not 0-4)
Solution: Frequency: 1,2, or 4 only. Basis: 0-4 range
#NUM! error
Cause: Settlement ≥ maturity date
Solution: Ensure settlement date is before maturity
Notes
- Excel stores dates as serial numbers (Jan 1, 1900 = 1)
- All arguments truncated to integers
- Use with COUPDAYS, COUPNCD, COUPPCD for complete bond analysis
- Settlement is purchase date, not issue date
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+