# COUPNUM

The `COUPNUM` 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.

## Usage

Use the `COUPNUM` formula with the syntax shown below, it has 3 required parameters and 1 optional parameter:

Parameters:
1. settlement (required):
The settlement date of the security. This is the date on which the buyer purchases the security.
2. maturity (required):
The maturity date of the security. This is the date on which the security expires and the issuer must repay the principal.
3. frequency (required):
The number of coupon payments per year. For example, if the security pays interest semi-annually, the frequency would be 2.
4. 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 the `COUPNUM` 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.

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.

You can learn more about the `COUPNUM` Google Sheets function on Google Support.