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

Introducci\u00f3n a la funci\u00f3n DIAS<\/h2>\n

La funci\u00f3n DIAS<\/strong> en Excel y Google Sheets se utiliza para calcular el n\u00famero de d\u00edas que hay entre dos fechas determinadas.<\/p>\n

Sintaxis y ejemplos de uso<\/h2>\n

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

=DIAS(fecha_fin, fecha_inicio)<\/code><\/pre>\n
    \n
  • fecha_fin<\/strong> – Corresponde a la fecha final del per\u00edodo a calcular. Esta fecha debe ser posterior a la fecha_inicio<\/em>.<\/li>\n
  • fecha_inicio<\/strong> – Indica la fecha inicial desde la cual se empezar\u00e1n a contar los d\u00edas.<\/li>\n<\/ul>\n
    Un ejemplo simple de su uso ser\u00eda:<\/p>\n
    =DIAS(\"2023-12-31\", \"2023-01-01\")<\/code><\/pre>\n
    Este ejemplo calcular\u00eda el n\u00famero de d\u00edas en el a\u00f1o 2023, que asumiendo no es un a\u00f1o bisiesto, resultar\u00eda en 365 d\u00edas.<\/p>\n
    Aplicaciones pr\u00e1cticas<\/h2>\n
    1. C\u00e1lculo de diferencia de d\u00edas para pr\u00e9stamos<\/h3>\n
    Por ejemplo, para calcular cu\u00e1ntos d\u00edas han pasado desde el inicio de un pr\u00e9stamo hasta el d\u00eda de hoy, que es fundamental para el c\u00e1lculo de intereses basados en d\u00edas, se puede usar:<\/p>\n
    =DIAS(HOY(), \"2023-01-01\")<\/code><\/pre>\n
    Si hoy es el 31 de diciembre de 2023, la f\u00f3rmula retornar\u00eda 364 d\u00edas, que es el tiempo que ha transcurrido desde el 1 de enero de 2023 hasta el d\u00eda antes del 31 de diciembre de 2023.<\/p>\n
    2. Gesti\u00f3n de proyectos<\/h3>\n
    En administraci\u00f3n de proyectos, conocer la duraci\u00f3n exacta en d\u00edas entre dos fechas puede ayudar a planificar plazos y a entender mejor la duraci\u00f3n total del proyecto. Por ejemplo:<\/p>\n
    =DIAS(\"2023-04-30\", \"2023-04-01\")<\/code><\/pre>\n
    Este c\u00e1lculo indicar\u00eda que el proyecto tuvo una duraci\u00f3n de 29 d\u00edas.<\/p>\n
    Conclusi\u00f3n<\/h2>\n
    Dominar la funci\u00f3n DIAS<\/strong> en Excel y Google Sheets te permite realizar c\u00e1lculos de tiempo de manera efectiva y precisa, lo cual es invaluable en \u00e1reas como la gesti\u00f3n financiera, la administraci\u00f3n de proyectos, y cualquier actividad que requiera seguimiento de per\u00edodos de tiempo espec\u00edficos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la cantidad de d\u00edas entre dos fechas<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[546],"tags":[],"class_list":["post-13914","post","type-post","status-publish","format-standard","hentry","category-fecha-y-hora"],"acf":[],"yoast_head":"\nFunci\u00f3n DAYS (DIAS) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n DAYS (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\/days\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n DAYS (DIAS) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n DAYS (DIAS) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/days\/\" \/>\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:45:06+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 DAYS (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\/days\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/days\/\",\"name\":\"Funci\u00f3n DAYS (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:45:06+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n DAYS (DIAS) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/days\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/days\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/days\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fecha y hora\",\"item\":\"https:\/\/functiontranslator.com\/es\/fecha-y-hora\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"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 DAYS (DIAS) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n DAYS (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\/days\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n DAYS (DIAS) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n DAYS (DIAS) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/days\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:45:06+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n DAYS (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\/days\/","url":"https:\/\/functiontranslator.com\/es\/days\/","name":"Funci\u00f3n DAYS (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:45:06+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n DAYS (DIAS) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/days\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/days\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/days\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Fecha y hora","item":"https:\/\/functiontranslator.com\/es\/fecha-y-hora\/"},{"@type":"ListItem","position":3,"name":"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\/13914","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=13914"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13914\/revisions"}],"predecessor-version":[{"id":29977,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13914\/revisions\/29977"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13914"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}