Financial

COUPDAYSNC Function in Excel

Returns the number of days from the settlement date to the next coupon date.

Syntax

  • =COUPDAYSNC(settlement, maturity, frequency, [basis])

Arguments

  • settlement (required): Settlement date
  • maturity (required): Maturity date
  • frequency (required): Payments per year (1, 2, or 4)
  • basis (optional): Day count basis

Examples

  • =COUPDAYSNC("1/25/2024", "11/15/2027", 2) - Days to next coupon - Result: 110

COUPDAYSNC modeling tips

  • Align rate and period units (annual rate ÷ 12 for monthly models).
  • Use consistent cash-flow signs (outflows negative, inflows positive).
  • Hub: [Financial functions guide](/guides/excel-financial-functions-guide/).

Common errors

  • #NUM! if dates invalid

Use cases

  • Bond pricing
  • Cash flow timing
  • Fixed income

Frequently asked questions

  • What is the COUPDAYSNC function in Excel? COUPDAYSNC returns the number of days from the settlement date to the next coupon date. The syntax is =COUPDAYSNC(settlement, maturity, frequency, [basis]). Typical use cases include bond pricing, cash flow timing, fixed income.
  • How do I use the COUPDAYSNC function? To use COUPDAYSNC, type =COUPDAYSNC( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • Why is COUPDAYSNC not working in my Excel? Common issues with COUPDAYSNC include #NUM! if dates invalid. Start by checking the syntax =COUPDAYSNC(settlement, maturity, frequency, [basis]), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.