All versions
Financial
The Excel COUPPCD function returns the previous coupon date before the settlement date. Settlement and maturity are dates wrap them in DATE() so Excel reads them correctly..
Quick answer:
=COUPPCD(DATE(2026,3,15), DATE(2031,1,1), 2) // a coupon date
Syntax
=COUPPCD(settlement, maturity, frequency, [basis])
| Argument | Description | |
|---|---|---|
settlement | Required | Settlement date. |
maturity | Required | Maturity date. |
frequency | Required | Coupons per year (1, 2, or 4). |
basis | Optional | Day-count basis. |
How to use it
COUPPCD returns the previous coupon date before the settlement date. Settlement and maturity are dates wrap them in DATE() so Excel reads them correctly..
=COUPPCD(DATE(2026,3,15), DATE(2031,1,1), 2) // a coupon date
Try it: interactive demo
Live demo
This is the formula pattern COUPPCD uses — copy it into Excel with your own numbers.
Result: computed in Excel
Practice workbook
Download the free COUPPCD practice workbook
Every example on this page, ready to open in Excel — plus practice challenges with answers on a separate tab. No sign-up required.
Frequently asked questions
How do I enter the dates?
Wrap settlement and maturity in DATE(year,month,day) so Excel reads real dates, not text.
Which Excel versions support it?
All modern versions.
Why might it return #NUM! or #VALUE!?
Out-of-range arguments (e.g. negative rate or settlement after maturity) give #NUM!; non-numeric inputs give #VALUE!.
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class