Wauvel

Excel like a finance pro.

← The library

Financial function

COUPDAYSNC

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

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

When to use it

Days from settlement to the next coupon date.

The shape of it

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

Worked examples

  • Days to next coupon

    =COUPDAYSNC(DATE(2011,1,25),DATE(2011,11,15),2,1) → 110

    Until May 15.

  • 30/360 basis

    =COUPDAYSNC(DATE(2025,3,1),DATE(2030,1,1),2,0) → 120

    Until July 1 under 30/360.

  • On a coupon date

    =COUPDAYSNC(DATE(2025,1,1),DATE(2030,1,1),2,0) → 180

    A full period ahead.

Worth knowing

  • COUPDAYBS + COUPDAYSNC = COUPDAYS.
  • COUPNCD gives the date itself.
  • Basis affects the count.

Where it goes wrong

  • #NUM! for invalid frequency or basis.
  • 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.