Functions
COUPDAYS
Days in coupon period
Try it
When to use it
When should I use COUPDAYS?
Use COUPDAYS to get the total number of days in the coupon period that contains the settlement date — needed when prorating accrued interest on a bond.
Used in
Syntax
COUPDAYS(settlement, maturity, frequency, [basis])Examples
=COUPDAYS(DATE(2010,2,1),DATE(2019,12,31),4) // => 90
=COUPDAYS(DATE(2010,2,1),DATE(2019,12,31),4,1) // => 90