Wauvel

Excel like a finance pro.

← The library

Financial function

COUPDAYS

Returns the number of days in the coupon period that contains the settlement date.

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

When to use it

The number of days in the coupon period that contains the settlement date.

The shape of it

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

Worked examples

  • Actual/actual

    =COUPDAYS(DATE(2011,1,25),DATE(2011,11,15),2,1) → 181

    November 15 to May 15, actual days.

  • 30/360 basis

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

    Semiannual under 30/360 is always 180.

  • Quarterly

    =COUPDAYS(DATE(2025,3,1),DATE(2030,1,1),4,0) → 90

    Quarterly under 30/360.

Worth knowing

  • Under basis 0 and 4 the answer is fixed by frequency.
  • Under basis 1 it depends on the actual months.
  • Denominator of the accrued-interest fraction.

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.