The COUPNCD function in Excel returns the next coupon date after the settlement date of a bond.In simple words, it helps you find out when the bond will make its next interest payment after you purchase it. This function is very helpful in bond investment calculations, pricing, and financial reporting.