The Excel function: COUPNUM
Description
Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.