Wauvel

Excel like a finance pro.

← The library

Financial function

COUPPCD

Returns the previous coupon date before settlement.

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

When to use it

The previous coupon date before settlement.

The shape of it

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

Worked examples

  • Previous coupon

    =COUPPCD(DATE(2011,1,25),DATE(2011,11,15),2,1) → 11/15/2010

    The November coupon.

  • Semiannual

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

    Coupons on January 1 and July 1.

  • On a coupon date

    =COUPPCD(DATE(2025,1,1),DATE(2030,1,1),2) → 1/1/2025

    Settlement on a coupon date returns that date.

Worth knowing

  • Start of the accrual period for ACCRINT.
  • Format as a date.
  • COUPNCD for the next 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.