AI Assistant
Help Center AI Assistant is now available
Got questions about Feishu? Use our AI chat to find the answers.
00:00
Click and hold to drag
Got It
Try Now

COUPDAYS function for Sheets

1 min read
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
  1. Select a cell and click Formulas on the toolbar, then select Financial > COUPDAYS. You can also directly enter =COUPDAYS in a cell.
  1. Enter the parameters in the cell. For example: =COUPDAYS(B1,B2,B3,B4).
  1. 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.
Written by: Feishu Help Center
Updated on 2022/09/14
Was this content helpful?

默认标题

Yes
Not really
Thank you for your feedback!
Need more help? Please contact Support.
0
rangeDom