Functions
COUPPCD
Previous coupon date before settlement
Try it
When to use it
When should I use COUPPCD?
Use COUPPCD to find the coupon date immediately before the settlement date — typically needed to calculate how much interest has accrued since the last payment.
Used in
Syntax
COUPPCD(settlement, maturity, frequency, [basis])Examples
=COUPPCD(DATE(2010,2,1),DATE(2019,12,31),4) // => 40178
=COUPPCD(DATE(2011,1,25),DATE(2011,11,15),2,1) // => 40497