Formulas > =COUPDAYBS()

How To Use COUPDAYBS() Function in Google Sheets


Calculates the number of days from the first coupon, or interest payment, until settlement.

Common questions about the COUPDAYBS formula:
- What does COUPDAYBS stand for?
- What does the COUPDAYBS formula do?
- What types of inputs are needed to use the formula?

How can the COUPDAYBS formula be used appropriately:
The COUPDAYBS formula calculates the number of days between two given dates, taking into account leap years and the following conventions: the month of Coupon Payment and the month of Coupon Basis Date. This can be used appropriately to calculate the number of days between two sets of coupon payments, the number of days between the bond's issue date and the coupon payment date, the number of days between a given coupon's payment date and the date it is set to expire, and more.

How can the COUPDAYBS formula be commonly mistyped:

What are some common ways the COUPDAYBS formula is used inappropriately:
The COUPDAYBS formula should not be used to calculate the difference in days between two dates that are different years. It should also not be used to forecast future coupon dates, since the formula cannot account for changes in leap years and other conditions.

What are some common pitfalls when using the COUPDAYBS formula:
It is important to make sure that the dates entered into the formula are in the same format (e.g. mm/dd/yyyy) as the formula uses. Additionally, the dates must be in the same month, or the formula will not work correctly.

What are common mistakes when using the COUPDAYBS Formula:
Some common mistakes made when using the COUPDAYBS formula include entering the wrong dates, entering dates in an incorrect format, mistyping the formula as COUP DAY BS or COUP DAY BSD, and not accounting for leap years.

What are common misconceptions people might have with the COUPDAYBS Formula:
Some common misconceptions people might have with the COUPDAYBS Formula include assuming it can be used to calculate coupon payments into the future, and assuming it only works if the two dates are in the same year.

How To Actually Use COUPDAYBS() in Sheets

COUPDAYBS(settlement, maturity, frequency, [day_count_convention])

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

Learn more about the COUPDAYBS() formula:

Generate a COUPDAYBS() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.