Formulas > =COUPDAYS()
How to Use COUPDAYS() in Google Sheets
Description
How To Actually Use COUPDAYS() in Sheets
COUPDAYS(settlement, maturity, frequency, [day_count_convention])
Try COUPDAYS yourself
Use the COUPDAYS formula to calculate the number of days in the coupon period for the bond with settlement date in cell A1 and maturity date in cell B1. Assume a frequency of 2.
Hints (2)
-
Remember to reference the correct cells for settlement and maturity dates.
-
The frequency for semiannual payments is 2.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the COUPDAYS() formula:
Generate a COUPDAYS() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses COUPDAYS(). 2 free AI generations, no signup. Members get unlimited use.
Generate a COUPDAYS() formula