Formulas > =COUPDAYSNC()
How to Use COUPDAYSNC() in Google Sheets
Description
How To Actually Use COUPDAYSNC() in Sheets
COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])
Try COUPDAYSNC yourself
In cells A1 and A2, enter the settlement date and maturity date respectively. Use the COUPDAYSNC formula in cell A3 to calculate the number of days until the next coupon payment based on a frequency of 2.
Hints (2)
-
Make sure your dates are in a valid date format.
-
Remember to set the frequency to 2 for semi-annual payments.
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 COUPDAYSNC() formula:
Generate a COUPDAYSNC() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses COUPDAYSNC(). 2 free AI generations, no signup. Members get unlimited use.
Generate a COUPDAYSNC() formula