{"id":13888,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/cupon-dias-l1\/"},"modified":"2021-02-26T08:44:21","modified_gmt":"2021-02-26T08:44:21","slug":"coupdaybs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/coupdaybs\/","title":{"rendered":"CUPON.DIAS.L1"},"content":{"rendered":"<h2>Introducci\u00f3n a CUPON.DIAS.L1 en Excel<\/h2>\n<p>La funci\u00f3n <code>CUPON.DIAS.L1<\/code> en Microsoft Excel, tambi\u00e9n conocida como <code>COUPDAYBS<\/code> en las versiones en ingl\u00e9s, se utiliza para calcular el n\u00famero de d\u00edas desde el inicio del per\u00edodo de un cup\u00f3n hasta la fecha de liquidaci\u00f3n. Esta funci\u00f3n es esencial en finanzas, en especial para el an\u00e1lisis y gesti\u00f3n de bonos con pagos de intereses peri\u00f3dicos.<\/p>\n<h2>Sintaxis y Ejemplos de Uso<\/h2>\n<p>La sintaxis de <code>CUPON.DIAS.L1<\/code> es:<\/p>\n<pre><code>CUPON.DIAS.L1(fecha_liquidaci\u00f3n, fecha_vencimiento, frecuencia, [base])<\/code><\/pre>\n<ul>\n<li><b>fecha_liquidaci\u00f3n:<\/b> Es la fecha hasta la cual se cuentan los d\u00edas.<\/li>\n<li><b>fecha_vencimiento:<\/b> Es la fecha en la que el bono expira.<\/li>\n<li><b>frecuencia:<\/b> Representa la cantidad de pagos de cup\u00f3n por a\u00f1o. Las opciones son 1, 2 o 4.<\/li>\n<li><b>base:<\/b> (Opcional) Es el tipo de conteo de d\u00edas utilizado. Puede ser:\n<ul>\n<li>0 o omitido: Base NASD de 30\/360.<\/li>\n<li>1: Real\/real.<\/li>\n<li>2: Real\/360.<\/li>\n<li>3: Real\/365.<\/li>\n<li>4: Europeo de 30\/360.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Ejemplo de uso en Excel:<\/p>\n<pre><code>= CUPON.DIAS.L1(\"01-01-2023\", \"31-12-2028\", 2)<\/code><\/pre>\n<p>Este ejemplo muestra c\u00f3mo calcular el n\u00famero de d\u00edas desde el \u00faltimo pago de cup\u00f3n hasta el 1 de enero de 2023, asumiendo pagos semestrales y utilizando la base NASD 30\/360 predeterminada.<\/p>\n<h2>Aplicaciones Pr\u00e1cticas<\/h2>\n<p>A continuaci\u00f3n, exploramos dos escenarios pr\u00e1cticos de uso de <code>CUPON.DIAS.L1<\/code> con soluciones detalladas.<\/p>\n<h2>Caso 1: C\u00e1lculo de D\u00edas en un Bono Semestral<\/h2>\n<p>Imagine un bono con pagos semestrales emitido el 15 de marzo de 2015 y que vence el 15 de marzo de 2025. Queremos determinar el n\u00famero de d\u00edas desde el inicio del \u00faltimo per\u00edodo del cup\u00f3n hasta una fecha de liquidaci\u00f3n espec\u00edfica, como el 01-01-2023.<\/p>\n<pre><code>F\u00f3rmula usada: = CUPON.DIAS.L1(\"01-01-2023\", \"15-03-2025\", 2) Resultado estimado: Ser\u00e1 la cantidad de d\u00edas desde el 15 de septiembre de 2022 (\u00faltimo inicio de per\u00edodo antes del 01-01-2023) hasta el 01-01-2023.<\/code><\/pre>\n<h2>Caso 2: Evaluaci\u00f3n de Diferentes Bases<\/h2>\n<p>Usando el mismo bono del caso anterior, comparemos los d\u00edas calculados con diferentes bases para una misma fecha de liquidaci\u00f3n.<\/p>\n<table>\n<tr>\n<th>Base<\/th>\n<th>F\u00f3rmula<\/th>\n<th>D\u00edas Calculados<\/th>\n<\/tr>\n<tr>\n<td>Real\/real (1)<\/td>\n<td><code>= CUPON.DIAS.L1(\"01-01-2023\", \"15-03-2025\", 2, 1)<\/code><\/td>\n<td>El resultado var\u00eda seg\u00fan los d\u00edas reales entre las fechas.<\/td>\n<\/tr>\n<tr>\n<td>Real\/360 (2)<\/td>\n<td><code>= CUPON.DIAS.L1(\"01-01-2023\", \"15-03-2025\", 2, 2)<\/code><\/td>\n<td>Se calcula sobre la base de 360 d\u00edas al a\u00f1o.<\/td>\n<\/tr>\n<\/table>\n<p>Estos ejemplos muestran c\u00f3mo diferentes bases de conteo pueden influir en el an\u00e1lisis financiero de bonos, permitiendo adaptaciones a necesidades contables o de inversi\u00f3n espec\u00edficas.<\/p>\n<p> <\/body> <\/html><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Devuelve el n\u00famero de d\u00edas desde el principio del per\u00edodo de un cup\u00f3n hasta 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-13888","post","type-post","status-publish","format-standard","hentry","category-finanzas"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Funci\u00f3n COUPDAYBS (CUPON.DIAS.L1) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n COUPDAYBS (CUPON.DIAS.L1) 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\/coupdaybs\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n COUPDAYBS (CUPON.DIAS.L1) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n COUPDAYBS (CUPON.DIAS.L1) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/coupdaybs\/\" \/>\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:21+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 COUPDAYBS (CUPON.DIAS.L1) 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\/coupdaybs\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/coupdaybs\/\",\"name\":\"Funci\u00f3n COUPDAYBS (CUPON.DIAS.L1) 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:21+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n COUPDAYBS (CUPON.DIAS.L1) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/coupdaybs\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/coupdaybs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/coupdaybs\/#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.L1\"}]},{\"@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 COUPDAYBS (CUPON.DIAS.L1) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n COUPDAYBS (CUPON.DIAS.L1) 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\/coupdaybs\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n COUPDAYBS (CUPON.DIAS.L1) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n COUPDAYBS (CUPON.DIAS.L1) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/coupdaybs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:44:21+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n COUPDAYBS (CUPON.DIAS.L1) 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\/coupdaybs\/","url":"https:\/\/functiontranslator.com\/es\/coupdaybs\/","name":"Funci\u00f3n COUPDAYBS (CUPON.DIAS.L1) 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:21+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n COUPDAYBS (CUPON.DIAS.L1) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/coupdaybs\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/coupdaybs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/coupdaybs\/#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.L1"}]},{"@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\/13888","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=13888"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13888\/revisions"}],"predecessor-version":[{"id":29951,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13888\/revisions\/29951"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13888"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13888"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}