The COUPNUM function in Excel calculates the number of coupon periods between the settlement date and the maturity date of a bond. In simple words, it tells you how many interest payments are left for the bond from the purchase date until it matures. This function is very useful for bond investment analysis, amortization schedules, and pricing bonds.