Formulas > =COUPNCD()
How to Use COUPNCD() in Google Sheets
Description
How To Actually Use COUPNCD() in Sheets
COUPNCD(settlement, maturity, frequency, [day_count_convention])
Try COUPNCD yourself
In cells A1 and A2, enter the settlement date and maturity date respectively. Use the COUPNCD formula in cell A3 to calculate the next coupon date for a frequency of 2 (semiannual).
Hints (2)
-
Make sure the dates in A1 and A2 are formatted correctly.
-
Remember that frequency refers to how often the coupon is paid.
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 COUPNCD() formula:
Generate a COUPNCD() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses COUPNCD(). 2 free AI generations, no signup. Members get unlimited use.
Generate a COUPNCD() formula