Formulas > =COUPNUM()
How to Use COUPNUM() in Google Sheets
Description
How To Actually Use COUPNUM() in Sheets
COUPNUM(settlement, maturity, frequency, [day_count_convention])
Try COUPNUM yourself
In cells A1 and A2, enter the settlement date and maturity date respectively. Use the COUPNUM formula in cell A3 to calculate the number of coupon payments between these dates, assuming a frequency of 2.
Hints (2)
-
Remember to format the dates correctly in A1 and A2.
-
The frequency represents how many coupon payments are made 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 COUPNUM() formula:
Generate a COUPNUM() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses COUPNUM(). 2 free AI generations, no signup. Members get unlimited use.
Generate a COUPNUM() formula