{"id":10811,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/cupdias\/"},"modified":"2021-02-25T17:16:11","modified_gmt":"2021-02-25T17:16:11","slug":"coupdays","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/coupdays\/","title":{"rendered":"CUPDIAS"},"content":{"rendered":"

Introdu\u00e7\u00e3o \u00e0 Fun\u00e7\u00e3o COUPDAYS (CUPDIAS)<\/h2>\n

A fun\u00e7\u00e3o COUPDAYS (CUPDIAS em portugu\u00eas) no Excel e nas Google Planilhas \u00e9 utilizada para calcular o n\u00famero total de dias no per\u00edodo de cupom atual, baseado no intervalo entre as datas de pagamento do cupom. Esta fun\u00e7\u00e3o \u00e9 particularmente valiosa no campo financeiro, mais especificamente na an\u00e1lise de t\u00edtulos que possuem pagamentos peri\u00f3dicos de juros.<\/p>\n

Sintaxe e Exemplos<\/h2>\n

A sintaxe da fun\u00e7\u00e3o COUPDAYS \u00e9 a seguinte:<\/p>\n

COUPDAYS(settle, maturity, frequency, [basis])<\/code><\/pre>\n
    \n
  • settle<\/strong> – A data de liquida\u00e7\u00e3o do t\u00edtulo, ou seja, a data a partir da qual o comprador passa a ser propriet\u00e1rio do t\u00edtulo adquirido.<\/li>\n
  • maturity<\/strong> – A data de vencimento do t\u00edtulo, isto \u00e9, o dia em que o t\u00edtulo expira.<\/li>\n
  • frequency<\/strong> – A frequ\u00eancia dos pagamentos de cupom ao ano (1 = anual, 2 = semestral, 4 = trimestral).<\/li>\n
  • basis<\/strong> (opcional) – O m\u00e9todo de contagem de dias utilizado (0 = 30\/360 US (padr\u00e3o), 1 = real\/real, 2 = 30\/360 EU, 3 = 30\/360 ITL, 4 = 30E\/360).<\/li>\n<\/ul>\n
    Exemplo pr\u00e1tico:<\/p>\n
    F\u00f3rmula:<\/strong> =COUPDAYS(\"15\/05\/2023\", \"15\/05\/2030\", 2) Resultado:<\/strong> 180<\/code><\/pre>\n
    No exemplo acima, a fun\u00e7\u00e3o estima que existem 180 dias no per\u00edodo do cupom para um t\u00edtulo com pagamentos semestrais, usando a base padr\u00e3o 0 (30\/360 US).<\/p>\n
    Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n
    Veja abaixo duas situa\u00e7\u00f5es em que a fun\u00e7\u00e3o CUPDIAS pode ser extremamente \u00fatil:<\/p>\n
    1. Calculando o Per\u00edodo do Cupom para Diferentes Frequ\u00eancias de Pagamento<\/h2>\n
    Imagine que voc\u00ea deseja comparar t\u00edtulos com diferentes frequ\u00eancias de pagamento para avaliar o impacto dos fluxos de receita de juros em seu portf\u00f3lio de investimentos.<\/p>\n
    =COUPDAYS(\"01\/01\/2023\", \"01\/01\/2033\", 1) \/\/ Devolve 360, indicando um per\u00edodo anual =COUPDAYS(\"01\/01\/2023\", \"01\/01\/2033\", 2) \/\/ Devolve 180, indicando per\u00edodos semestrais =COUPDAYS(\"01\/01\/2023\", \"01\/01\/2033\", 4) \/\/ Devolve 90, indicando per\u00edodos trimestrais<\/code><\/pre>\n
    Neste exemplo, \u00e9 poss\u00edvel observar o total de dias em cada per\u00edodo de cupom, dependendo da frequ\u00eancia de pagamentos anual, semestral e trimestral, todos considerando a mesma base padr\u00e3o.<\/p>\n
    2. Avaliando o Impacto do Tipo de Contagem de Dias<\/h2>\n
    Um investidor pode desejar entender como diferentes m\u00e9todos de contagem de dias afetam a dura\u00e7\u00e3o dos per\u00edodos de cupom.<\/p>\n
    =COUPDAYS(\"15\/03\/2023\", \"15\/03\/2028\", 2, 0) \/\/ Usa 30\/360 US, resultado 180 =COUPDAYS(\"15\/03\/2023\", \"15\/03\/2028\", 2, 1) \/\/ Usa real\/real, o resultado pode variar dependendo dos dias reais do per\u00edodo<\/code><\/pre>\n
    Comparando os resultados para diferentes bases, como 30\/360 US e real\/real, nos per\u00edodos semestrais, \u00e9 poss\u00edvel notar varia\u00e7\u00f5es que podem influenciar decis\u00f5es financeiras ou cont\u00e1beis significativas.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devolve o n\u00famero de dias no per\u00edodo do cup\u00e3o que cont\u00e9m a data de regulariza\u00e7\u00e3o<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[438],"tags":[],"class_list":["post-10811","post","type-post","status-publish","format-standard","hentry","category-financeira"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o COUPDAYS (CUPDIAS) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o COUPDAYS (CUPDIAS) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos 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\/pt-pt\/coupdays\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o COUPDAYS (CUPDIAS) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o COUPDAYS (CUPDIAS) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/coupdays\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:16:11+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o COUPDAYS (CUPDIAS) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\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\/pt-pt\/coupdays\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/coupdays\/\",\"name\":\"Fun\u00e7\u00e3o COUPDAYS (CUPDIAS) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-25T17:16:11+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o COUPDAYS (CUPDIAS) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/coupdays\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/coupdays\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/coupdays\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Financeira\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/financeira\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CUPDIAS\"}]},{\"@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\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o COUPDAYS (CUPDIAS) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o COUPDAYS (CUPDIAS) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos 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\/pt-pt\/coupdays\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o COUPDAYS (CUPDIAS) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o COUPDAYS (CUPDIAS) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/coupdays\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:16:11+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o COUPDAYS (CUPDIAS) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/coupdays\/","url":"https:\/\/functiontranslator.com\/pt-pt\/coupdays\/","name":"Fun\u00e7\u00e3o COUPDAYS (CUPDIAS) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-25T17:16:11+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o COUPDAYS (CUPDIAS) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/coupdays\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/coupdays\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/coupdays\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Financeira","item":"https:\/\/functiontranslator.com\/pt-pt\/financeira\/"},{"@type":"ListItem","position":3,"name":"CUPDIAS"}]},{"@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":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10811","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=10811"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10811\/revisions"}],"predecessor-version":[{"id":25640,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10811\/revisions\/25640"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}