Functions
COUPNUM
Number of coupons between settlement and maturity
Try it
When to use it
When should I use COUPNUM?
Use COUPNUM to count the total number of coupon payments remaining between the settlement date and maturity — useful for bond cash-flow analysis.
Used in
Syntax
COUPNUM(settlement, maturity, frequency, [basis])Examples
=COUPNUM(DATE(2010,2,1),DATE(2019,12,31),4) // => 40
=COUPNUM(DATE(2007,1,25),DATE(2008,11,15),2,1) // => 4