I. Intro
The COUPDAYBS function returns the number of days from the first coupon (or interest payment) date until the settlement date.
II. About the function
- Formula: =COUPDAYBS(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: =COUPDAYBS("2010-2-1","2019-12-31",4,0)
III. Steps
Use the COUPDAYBS function
- Select a cell and click Formulas on the toolbar, then select Financial > COUPDAYBS. You can also directly enter =COUPDAYBS in a cell.
- Enter the parameters in the cell. For example: =COUPDAYBS(B1,B2,B3,B4).
- Press Enter to display the result in the cell, which is 31 in this example.
250px|700px|reset
Delete the COUPDAYBS function
Select the cell with the COUPDAYBS function, and press Delete.