Formulas > =COUPDAYBS()
How to Use COUPDAYBS() in Google Sheets
Description
How To Actually Use COUPDAYBS() in Sheets
COUPDAYBS(settlement, maturity, frequency, [day_count_convention])
Try COUPDAYBS yourself
Use the COUPDAYBS formula in cell D1 to calculate the number of days from the first coupon payment until the settlement date in cell A1, with the maturity date in cell B1 and a frequency of 2. The result should be a positive integer.
Hints (2)
-
Remember to reference the correct cells for settlement and maturity dates.
-
The frequency parameter indicates how often coupons are paid per year.
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 COUPDAYBS() formula:
Generate a COUPDAYBS() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses COUPDAYBS(). 2 free AI generations, no signup. Members get unlimited use.
Generate a COUPDAYBS() formula