{"id":13889,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/cupon-dias\/"},"modified":"2021-02-26T08:44:24","modified_gmt":"2021-02-26T08:44:24","slug":"coupdays","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/coupdays\/","title":{"rendered":"CUPON.DIAS"},"content":{"rendered":"

Descripci\u00f3n General<\/h2>\n

La funci\u00f3n CUPON.DIAS en Excel y Google Sheets se utiliza para calcular el n\u00famero total de d\u00edas en el per\u00edodo de cup\u00f3n que incluye la fecha de liquidaci\u00f3n. Esta herramienta es esencial en an\u00e1lisis financieros, especialmente para bonos y otros instrumentos financieros que generan intereses de forma peri\u00f3dica.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n CUPON.DIAS es la siguiente:<\/p>\n

  CUPON.DIAS(fecha_liquidaci\u00f3n, fecha_vencimiento, frecuencia, [base]) <\/code> <\/pre>\n
    \n
  • fecha_liquidaci\u00f3n:<\/strong> Fecha en la que se realiza el c\u00e1lculo. Debe ser anterior a la fecha de vencimiento.<\/li>\n
  • fecha_vencimiento:<\/strong> Fecha en la cual el bono expira.<\/li>\n
  • frecuencia:<\/strong> N\u00famero de veces al a\u00f1o que se paga el cup\u00f3n (1 = anual, 2 = semestral, 4 = trimestral).<\/li>\n
  • base:<\/strong> (opcional) Sistema de conteo de d\u00edas utilizado (0 = 30\/360, 1 = actual\/actual, 2 = actual\/360, 3 = actual\/365, 4 = 30\/360 europeo).<\/li>\n<\/ul>\n
    Ejemplo:<\/strong> Para calcular el n\u00famero total de d\u00edas en el per\u00edodo de cup\u00f3n de un bono con una fecha de liquidaci\u00f3n del 15 de marzo de 2022 y fecha de vencimiento del 15 de marzo de 2027, con cupones anuales (frecuencia = 1), escribir\u00edamos:<\/p>\n
      =COUPDAYS(\"15\/03\/2022\", \"15\/03\/2027\", 1) <\/code> <\/pre>\n
    El resultado ser\u00eda 360, que se obtiene empleando el m\u00e9todo de conteo de d\u00edas 30\/360 por defecto.<\/p>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    La funci\u00f3n CUPON.DIAS se puede aplicar en diversos contextos financieros, como se muestra en los siguientes escenarios:<\/p>\n
    Escenario 1: C\u00e1lculo de d\u00edas en un bono semestral<\/h3>\n
    Consideremos un inversor que compra un bono con pagos de intereses semestrales y desea saber el n\u00famero de d\u00edas en el per\u00edodo de cup\u00f3n actual:<\/p>\n
      \n
    • Fecha de liquidaci\u00f3n: 01\/01\/2023<\/li>\n
    • Fecha de vencimiento: 01\/01\/2033<\/li>\n
    • Frecuencia: 2 (semestral)<\/li>\n
    • Base: 1 (actual\/actual)<\/li>\n<\/ul>\n
        =COUPDAYS(\"01\/01\/2023\", \"01\/01\/2033\", 2, 1) <\/code> <\/pre>\n
      Este c\u00e1lculo determina el n\u00famero real de d\u00edas en el per\u00edodo del cup\u00f3n utilizando el calendario actual.<\/p>\n
      Escenario 2: An\u00e1lisis de diversos bonos<\/h3>\n
      Un analista financiero compara varios bonos con diferentes fechas de vencimiento y frecuencias de pago para determinar cu\u00e1l ofrece el mejor retorno ajustado al tiempo:<\/p>\n\n\n\n\n
      Bono<\/th>\nFecha de Liquidaci\u00f3n<\/th>\nFecha de Vencimiento<\/th>\nFrecuencia<\/th>\nBase<\/th>\n<\/tr>\n
      A<\/td>\n01\/06\/2022<\/td>\n01\/06\/2032<\/td>\n1<\/td>\n0<\/td>\n<\/tr>\n
      B<\/td>\n01\/06\/2022<\/td>\n01\/12\/2025<\/td>\n4<\/td>\n2<\/td>\n<\/tr>\n<\/table>\n
        =COUPDAYS(\"01\/06\/2022\", \"01\/06\/2032\", 1, 0) \/\/ Resultado para el Bono A =COUPDAYS(\"01\/06\/2022\", \"01\/12\/2025\", 4, 2) \/\/ Resultado para el Bono B <\/code> <\/pre>\n
      Estos c\u00e1lculos permiten al analista tener una base clara para comparar los d\u00edas de cup\u00f3n y realizar un an\u00e1lisis financiero m\u00e1s detallado.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devuelve el n\u00famero de d\u00edas del per\u00edodo (entre dos cupones) donde se encuentra la fecha de liquidaci\u00f3n<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[536],"tags":[],"class_list":["post-13889","post","type-post","status-publish","format-standard","hentry","category-finanzas"],"acf":[],"yoast_head":"\nFunci\u00f3n COUPDAYS (CUPON.DIAS) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n COUPDAYS (CUPON.DIAS) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/es\/coupdays\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n COUPDAYS (CUPON.DIAS) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n COUPDAYS (CUPON.DIAS) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/coupdays\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:44:24+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n COUPDAYS (CUPON.DIAS) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/coupdays\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/coupdays\/\",\"name\":\"Funci\u00f3n COUPDAYS (CUPON.DIAS) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:44:24+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n COUPDAYS (CUPON.DIAS) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/coupdays\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/coupdays\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/coupdays\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finanzas\",\"item\":\"https:\/\/functiontranslator.com\/es\/finanzas\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CUPON.DIAS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n COUPDAYS (CUPON.DIAS) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n COUPDAYS (CUPON.DIAS) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/es\/coupdays\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n COUPDAYS (CUPON.DIAS) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n COUPDAYS (CUPON.DIAS) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/coupdays\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:44:24+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n COUPDAYS (CUPON.DIAS) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/coupdays\/","url":"https:\/\/functiontranslator.com\/es\/coupdays\/","name":"Funci\u00f3n COUPDAYS (CUPON.DIAS) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:44:24+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n COUPDAYS (CUPON.DIAS) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/coupdays\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/coupdays\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/coupdays\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Finanzas","item":"https:\/\/functiontranslator.com\/es\/finanzas\/"},{"@type":"ListItem","position":3,"name":"CUPON.DIAS"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13889","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=13889"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13889\/revisions"}],"predecessor-version":[{"id":29952,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13889\/revisions\/29952"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13889"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13889"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}