The COUPDAYS function


The COUPDAYS function <Post <Blog | SumProduct son expertos en capacitación de Excel: modelado financiero, modelado de datos estratégicos, auditoría de modelos, planificación y estrategia, cursos de capacitación, consejos y base de conocimiento en línea.

keep in mind javascript is needed for full functionality of the web portal.

Welcome back to our usual blog of Excel functions from A to Z. Today we look at the COUPDAYS function.

The COUPDAYS function

Cuando invierte en un bono con cupón, que es un bono que paga intereses antes del vencimiento, puede examinar su inversión con mayor precisión si conoce la cantidad de días del período del cupón. Para hallar ese valor, you can use the COUPDAYS function, que es la abreviatura de knockin days.

The COUPDAYS The function uses the following syntax to operate:

COUPDAYS (liquidation, expiration, frequency, [basis])

The COUPDAYS The function has the following arguments:

  • settlement: this represents the settlement date of the security. The settlement date of the security is the date after the issue date when the security is traded with the buyer.
  • maturity: this is the expiration date of the security, In other words when security expires
  • frequency: The number of coupon payments per year. For annual payments, frequency it is 1; for semester, frequency it is 2; for quarterly, frequency it is 4. These are the only options (look down)
  • base: the type of day count base to use. This is optional. There are five options:


Day Count Base

0 or omitted

United States (NASD) 30/360


Real / real


Real / 360


Actual / 365


European 30/360

It should be noted at the same time that:

  • microsoft excel stores dates as sequential serial numbers so that they can be used in calculations. By default, the 1 of January of 1900 is the serial number 1 and the 1 of January of 2008 is the serial number 39448 because it is 39,448 days after 1 of January of 1900.
  • dates must be entered using the DATE function, or as a consequence of other formulas or functions. As an example, use = DATE (2020,2,29) for him 29th February 2020. Problems can arise if dates are entered as text
  • the settlement date is the date a buyer purchases a coupon, as a bonus. The expiration date is the date a coupon expires. As an example, Suppose a bond is issued to 30 years the 1 of January of 2008 and a buyer buys it six months later. The issue date would be 1 of January of 2008, the settlement date would be 1 July 2008 and the expiration date would be 1 of January of 2038, 30 years after the date of issue of the 1 of January of 2008
  • all arguments are truncated to integers
  • And settlement O maturity is not a valid date, COUPDAYS return the #VALUE! error value
  • And frequency is any number other than 1, 2 O 4, COUPDAYS return the #ON ONE! error value
  • And base <0 o si base > 4, COUPDAYS return the #ON ONE! error value
  • And settlementmaturity, COUPDAYS return the #ON ONE! error value.

Please, see my example below:

Soon we will continue with our functions from A to Z of Excel. Keep checking: there is a new blog post every business day.

Subscribe to our Newsletter

We will not send you SPAM mail. We hate it as much as you.