ProductSolutionsTemplatesResources

COUPDAYS

Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. Learn more

Video field
Financial

The COUPDAYS function in Google Sheets is used to calculate the number of days between the settlement date and the next coupon payment date for a security that pays periodic interest.

The function takes four arguments:

settlement: the settlement date of the security. maturity: the maturity date of the security. frequency: the number of coupon payments per year. daycountconvention (optional): the day count basis to be used in the calculation. The day count convention parameter specifies the method used to calculate the fraction of a year between two dates. If this parameter is not provided, the function assumes a day count basis of 30/360.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!