Formulas > =COUPDAYSNC()

How To Use COUPDAYSNC() Function in Google Sheets


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

Common Questions About the COUPDAYSNC Formula:
1. What is the COUPDAYSNC formula?
2. What does the COUPDAYSNC formula do?
3. How do I use the COUPDAYSNC formula?

How Can the COUPDAYSNC Formula Be Used Appropriately?
The COUPDAYSNC formula calculates the number of days between two specified coupon dates, with 0 indicating that the two dates are the same. To appropriately use the COUPDAYSNC formula, one must enter two valid dates and ensure that the correct order of dates is entered (i.e. the initial date should be entered before the final date).

How Can the COUPDAYSNC Formula Be Commonly Mistyped?
The COUPDAYSNC formula can commonly be mistyped by omitting the “C” from the formula name. When entering the formula in Google Sheets, the formula should be typed as “COUPDAYSNC”. Some commonly mistyped words are COUPDAYS, COUPDAY, COUPDAYSN, COUPDAYSC, COUPDAYNC, COUPDAYS NC, COUPDAY NC, COUPEDAYSNC.

What are Some Common Ways the COUPDAYSNC Formula is Used Inappropriately?
The COUPDAYSNC formula can be used inappropriately by entering the wrong order of dates, entering dates in incorrect formats, or entering characters that are not valid for date formats.

What are Some Common Pitfalls When Using the COUPDAYSNC Formula?
Some common pitfalls when using the COUPDAYSNC formula include entering dates that are not valid, entering the wrong order of dates, and mistyping the formula’s name.

What are Common Mistakes When Using the COUPDAYSNC Formula?
Common mistakes when using the COUPDAYSNC formula include mistyping the formula name, entering dates that are not valid, and mixing information from different cells (e.g. mixing text and number data) when inputting the dates into the formula.

What are Common Misconceptions People Might Have with the COUPDAYSNC Formula?
Common misconceptions people might have with the COUPDAYSNC formula include thinking that the formula will only work with specific date formats, or that the formula is only capable of calculating the total number of days between two dates. However, COUPDAYSNC can calculate days between any two dates, regardless of the format, and not all dates need to be in the same format.

How To Actually Use COUPDAYSNC() in Sheets

COUPDAYSNC(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 COUPDAYSNC() formula:

Generate a COUPDAYSNC() 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. Free to try for non-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.