Skip to content
Excel

COUPNCD function in Excel

Returns the next coupon date after the settlement date

=COUPNCD(settlement, maturity, frequency, [basis])

COUPNCD 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.

COUPNCD examples

Formulas you'll actually reuse.

  1. The next coupon date after settlement:

    =COUPNCD(DATE(2026, 5, 15), DATE(2031, 3, 15), 2)

    Result2026-09-15

  2. Days until the next coupon of the bond in row 2:

    =COUPNCD(TODAY(), C2, 2) - TODAY()

COUPNCD in Google Sheets

Same name — your formula ports as-is.

Try COUPNCD in the playground

Edit the example — nothing to install.

Preloaded with the COUPNCD formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.