I. Intro
The COUPDAYS function returns the number of days between coupon or interest payments, including the settlement date.
II. About the function
- Formula: =COUPDAYS(settlement,maturity,frequency,[day_count_convention])
- Parameters:
- settlement (required): The settlement date of the security (the date after the issue date when the buyer takes ownership of the security).
- maturity (required): The maturity date or end date of the security (the date when the security can be redeemed at face or par value).
- frequency (required): The number of coupon or interest payments per year (1, 2, or 4).
- [day_count_convention] (optional): The method used to calculate the number of days in a year. See COUPDAYSNC for more details.
- Example: =COUPDAYS("2010-2-1","2019-12-31",4,0)
III. Steps
Use the COUPDAYS function
- Select a cell and click Formulas on the toolbar, then select Financial > COUPDAYS. You can also directly enter =COUPDAYS in a cell.
- Enter the parameters in the cell. For example: =COUPDAYS(B1,B2,B3,B4).
- Press Enter to display the result, which is 90 in this example.
250px|700px|reset
Delete the COUPDAYS function
Select the cell with the COUPDAYS function, and press Delete.