81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Calculates last coupon, or interest payment, date before the settlement date.

How To Use in Sheets

COUPPCD(settlement, maturity, frequency, [day_count_convention])

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.