Wauvel

Excel like a finance pro.

← The library

Financial function

COUPDAYBS

Returns the number of days from the start of the coupon period to the settlement date.

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

When to use it

Days from the start of the current coupon period to the settlement date.

The shape of it

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

Worked examples

  • Days elapsed

    =COUPDAYBS(DATE(2011,1,25),DATE(2011,11,15),2,1) → 71

    Since the November 15 coupon.

  • 30/360 basis

    =COUPDAYBS(DATE(2025,3,1),DATE(2030,1,1),2,0) → 60

    Two 30-day months since January 1 under 30/360.

  • On a coupon date

    =COUPDAYBS(DATE(2025,1,1),DATE(2030,1,1),2,0) → 0

    Settlement on a coupon date.

Worth knowing

  • Accrued fraction is COUPDAYBS/COUPDAYS.
  • Frequency and basis must match the bond.
  • COUPPCD gives the date the count starts from.

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.