COUPNUM
TheCOUPNUM
formula calculates the number of coupons payable between the settlement date and maturity date of a security. This formula is commonly used in financial analysis to determine the amount of interest income earned on a bond or other fixed income security.
 How to use
COUPNUM
formula?  Examples of using
COUPNUM
formula COUPNUM
formula not working? Similar formulas to
COUPNUM
Usage
Use the COUPNUM
formula with the syntax shown below, it has 3 required parameters and 1 optional parameter:
 settlement (required):
The settlement date of the security. This is the date on which the buyer purchases the security.  maturity (required):
The maturity date of the security. This is the date on which the security expires and the issuer must repay the principal.  frequency (required):
The number of coupon payments per year. For example, if the security pays interest semiannually, the frequency would be 2.  day_count_convention (optional):
An optional argument that specifies the day count convention to use in the calculation. This argument is rarely used and can be omitted in most cases.
Examples
Here are a few example use cases that explain how to use theCOUPNUM
formula in Google Sheets.
Calculating interest income
One common use case of COUPNUM
is to calculate the amount of interest income earned on a bond or other fixed income security. By using this formula, you can determine how many coupon payments will be made before the security matures and calculate the total amount of interest earned.
Adjusting for different payment frequencies
In some cases, a security may pay interest more or less frequently than once per year. By using the COUPNUM
formula, you can adjust for this by specifying the correct frequency argument.
Determining holding periods
Investors may use the COUPNUM
formula to determine the length of time they have held a security. By subtracting the number of coupon payments from the maturity date, they can determine the number of days they have held the security and adjust their tax liability accordingly.
Common Mistakes
COUPNUM
not working? Here are some common mistakes people make when using the COUPNUM
Google Sheets Formula:
Incorrect date format
One common mistake when using COUPNUM is to enter the dates in an incorrect format, such as using text instead of a valid date format. Make sure to use a valid date format or convert the text to a date using the DATEVALUE function.
Missing arguments
Another mistake is to omit one or more required arguments in the COUPNUM formula. Make sure to include all required arguments, settlement, maturity, and frequency, and use brackets to indicate optional arguments.
Invalid settlement date
COUPNUM requires the settlement date to be before the maturity date. If the settlement date is after the maturity date, COUPNUM will return a #NUM! error. Make sure to enter the settlement date correctly.
Invalid frequency
COUPNUM requires the frequency argument to be a valid number, such as 1, 2, or 4. If an invalid frequency is used, COUPNUM will return a #NUM! error. Make sure to use a valid frequency argument.
Invalid day count convention
If an invalid day count convention is used, COUPNUM will return a #VALUE! error. Make sure to use a valid day count convention or omit the optional argument.
Related Formulas
The following functions are similar to COUPNUM
or are often used with it in a formula:

COUPDAYBS
The
COUPDAYBS
function calculates the number of days from the beginning of the coupon period to the settlement date for a security that pays periodic interest. It is commonly used in financial calculations to determine the accrued interest between the last coupon payment and the settlement date. 
COUPDAYS
The
COUPDAYS
function returns the number of days in the coupon period that contains the settlement date. This function is commonly used in financial analysis to calculate the number of days between two dates for interest rate calculations. 
COUPNCD
The
COUPNCD
function calculates the next coupon date after the settlement date for a security with periodic interest payments. It is commonly used in finance to determine the next coupon payment date for bonds and other fixed income securities. 
COUPPCD
The
COUPPCD
function calculates the previous coupon payment date for a security that pays periodic interest. It is commonly used in financial analysis to determine the last coupon payment date for a bond or other fixed income security.
Learn More
You can learn more about the COUPNUM
Google Sheets function on Google Support.