Wauvel

Excel like a finance pro.

← The library

Financial function

COUPNCD

Returns the next coupon date after settlement.

Rarely usedDifficulty 1550 · AdvancedUsage rank #432 of 520
Practice · 2 questions →

When to use it

The next coupon date after settlement.

The shape of it

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

Worked examples

  • Next coupon

    =COUPNCD(DATE(2011,1,25),DATE(2011,11,15),2,1) → 5/15/2011

    The May coupon.

  • Semiannual

    =COUPNCD(DATE(2025,3,1),DATE(2030,1,1),2) → 7/1/2025

    Coupons on January 1 and July 1.

  • Quarterly

    =COUPNCD(DATE(2025,3,1),DATE(2030,1,1),4) → 4/1/2025

    Quarterly coupons.

Worth knowing

  • Format the result as a date.
  • Coupon dates are counted back from maturity.
  • COUPPCD for the previous one.

Where it goes wrong

  • Shows a serial number until formatted.
  • Text dates return #VALUE!.

Related

PMTNPVIRRIPMTPPMTPV

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.