COUPNUM

COUPNUM helps you return the number of interest payments between a settlement date and a maturity date. It provides the tools you need to enter the function correctly, review its syntax, and troubleshoot common calculation issues, making your work more efficient and helping you accomplish tasks with ease. With COUPNUM, you can insert the function through the function dialog, type =COUPNUM(...) directly in a cell or formula bar, view the syntax COUPNUM(settlement, maturity, frequency, [basis]), and open detailed help for the function. Whether you're checking parameter types to resolve #VALUE! errors, verifying references and numeric formatting when results seem incorrect, or filling the formula across multiple cells while managing relative and absolute references, COUPNUM helps you stay productive. Choose the documentation below that best matches your needs to learn more.