COUPDAYS

Formulas / COUPDAYS
Calculate the number of days in a coupon period.
=COUPDAYS(settlement, maturity, frequency, [basis])
  • Settlement - required, date the security is transferred to the investor
  • Maturity - required, date when the investment ends and the principle plus accrued interest is returned to the investor
  • Frequency - how many interest payments happen per year
  • Basis - [OPTIONAL] determines the way that days are counted

Examples

  • =COUPDAYS(DATE(2019,2,15),DATE(2024,1,1),2,0)

    The function can be used to calculate the number of days between two dates. For example, this will calculate the number of days between February 15th, 2019 and January 1st, 2024.

  • =COUPDAYS(2019,2,15,2024,1,1,2,0)

    This function can also be used with hardcoded values for the arguments. This example will calculate the same number of days between February 15th, 2019 and January 1st, 2024 as the example above.

  • =COUPDAYS(C6,C7,C10,C11)

    The function can be used with cell references for the arguments as well. For example, if cell C6 contains the date February 15th, 2019, cell C7 contains the date January 1st, 2024, cell C10 contains the number 2, and cell C11 contains the number 0, then the formula will calculate the number of days between February 15th, 2019 and January 1st, 2024.

Summary

The COUPDAYS function is used to calculate the number of days in the coupon period for a security based on their settlement date. It requires four arguments - settlement, maturity, frequency and basis - for accurate results.

  • The COUPDAYS function returns the number of days in a coupon period and allows five different options for the basis argument.
  • The basis argument controls how days are counted and is used to calculate the number of days in a coupon period.


Frequently Asked Questions

What is the COUPDAYS function?
The COUPDAYS function is a financial function that returns the number of days in a coupon period.
What arguments does COUPDAYS take?
The COUPDAYS function takes three arguments:
  • Settlement date
  • Maturity date
  • Frequency
Are the arguments for COUPDAYS required?
Yes, all three arguments for COUPDAYS are required.
What error does COUPDAYS return if the frequency argument is not 1?
The COUPDAYS function returns a #NUM! error if the frequency argument is not 1, 2, or 4.

Related Functions

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.