COUPDAYSNC

Formulas / COUPDAYSNC
Calculate the number of days between the settlement date and the next coupon date.
==COUPDAYSNC(settlement, maturity, frequency, [basis])
  • settlement - the date the security is taken into possession by the investor
  • maturity - the date the investment ends
  • frequency - the number of interest payments per year
  • basis - [OPTIONAL] the method used to calculate the number of days

Examples

    =COUPDAYSNC(DATE(2019,2,15),DATE(2024,1,1),2,0) returns the same result as =COUPDAYSNC(C6,C7,C10,C11)

    =COUPDAYSNC(C6,C7,C10,C11) uses hardcoded values for the maturity date, settlement date, and frequency.

    =COUPDAYSNC(C6,C7,C10,C11) returns #VALUE! if settlement or maturity dates are not valid.

    =COUPDAYSNC(C6,C7,C10,C11) returns #NUM! if maturity date is not later than settlement date.


Summary

The COUPDAYSNC function returns the number of days between the settlement date and the next coupon date, based on three required arguments.

  • The COUPDAYSNC function returns the number of days from the settlement date to the next coupon date.
  • The settlement date is the date when an investor takes possession of a security and the maturity date is the date when the investment is finished with the principle and accrued interest returned to the investor.

Frequently Asked Questions

What is the COUPDAYSNC function?
The COUPDAYSNC function calculates the number of days from the settlement date to the next coupon rate.
What is the COUPDAYSNC function used for?
The COUPDAYSNC function is useful for calculating cash flows using efficient methods. It is also useful for calculating cash flows when using different dating methods.
What does the COUPDAYSNC function accept as input?
The COUPDAYSNC function accepts date formats.
What are some tips for using the COUPDAYSNC function?
  • Make sure to use the correct date format when inputting the settlement date
  • Know which dating method you are using when calculating cash flows
  • Be aware of leap years when calculating the number of days

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV