Functions
COUPDAYBS
Days from coupon start to settlement
Try it
When to use it
When should I use COUPDAYBS?
Use COUPDAYBS to find the number of days from the start of the current coupon period to the settlement date of a bond — essential for accrued-interest calculations.
Used in
Syntax
COUPDAYBS(settlement, maturity, frequency, [basis])Examples
=COUPDAYBS(DATE(2010,2,1),DATE(2019,12,31),4) // => 31
=COUPDAYBS(DATE(2010,2,1),DATE(2019,12,31),4,1) // => 32