COUPPCD
TheCOUPPCD
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.
 How to use
COUPPCD
formula?  Examples of using
COUPPCD
formula COUPPCD
formula not working? Similar formulas to
COUPPCD
Usage
Use the COUPPCD
formula with the syntax shown below, it has 3 required parameters and 1 optional parameter:
 settlement (required):
The settlement date of the security, represented as a date or a reference to a cell containing a date.  maturity (required):
The maturity date of the security, represented as a date or a reference to a cell containing a date.  frequency (required):
The number of coupon payments per year for the security, represented as a number.  day_count_convention (optional):
An optional argument that specifies the day count convention to use for the calculation. If omitted, it defaults to 1, which indicates the actual number of days between the settlement and previous coupon payment.
Examples
Here are a few example use cases that explain how to use theCOUPPCD
formula in Google Sheets.
Calculating the previous coupon payment date for a bond
Suppose you have a bond that pays semiannual coupons on January 1 and July 1. You want to know the last coupon payment date before a given settlement date. You can use the COUPPCD
function to calculate this date.
Determining the accrued interest for a bond
The accrued interest for a bond is the interest that has accumulated since the last coupon payment date. You can use the COUPPCD
function in conjunction with other financial functions to calculate the accrued interest for a given settlement date.
Forecasting future coupon payment dates for a bond
If you know the coupon payment frequency for a bond, you can use the COUPPCD
function to forecast future coupon payment dates. This can be useful in financial planning and analysis.
Common Mistakes
COUPPCD
not working? Here are some common mistakes people make when using the COUPPCD
Google Sheets Formula:
Using incorrect date formats
Make sure that the settlement and maturity dates are entered in a valid date format, such as a date serial number or a date string in quotes. If using cell references, ensure that the cell contains a valid date format.
Incorrectly specifying frequency
Doublecheck that the frequency argument is entered as a positive integer, representing the number of coupon payments per year. Entering a noninteger or negative value will result in an error.
Related Formulas
The following functions are similar to COUPPCD
or are often used with it in a formula:

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. 
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. 
DURATION
The
DURATION
function calculates the Macauley duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. The Macauley duration is a measure of the sensitivity of the price of the security to changes in interest rates. This function is commonly used in finance and investment analysis. 
YIELD
The YIELD function calculates the yield of a security that pays periodic interest. The yield is the annualized percentage rate returned on the bond, assuming the bond is held until maturity. This function is commonly used in finance and investment analysis.
Learn More
You can learn more about the COUPPCD
Google Sheets function on Google Support.