COUPPCD
Returns the previous coupon date before the settlement date.
FinancialFinance & Accounting
What it does
Calculates the coupon date immediately preceding the settlement date.
Syntax
COUPPCD(settlement, maturity, frequency, [basis])
Arguments
settlement(date) — Settlement date.maturity(date) — Maturity date.frequency(number) — Coupons per year.
Examples
Previous Coupon Date
Find previous payment date.
FORMULA
=COUPPCD(DATE(2023,1,25), DATE(2023,11,15), 2, 1)
RESULT
2022-11-15
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Settlement | Maturity |
| 2 | 2023-01-25 | 2023-11-15 |