{"id":14107,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/dias-lab-intl\/"},"modified":"2021-02-26T08:54:34","modified_gmt":"2021-02-26T08:54:34","slug":"networkdays-intl","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/networkdays-intl\/","title":{"rendered":"DIAS.LAB.INTL"},"content":{"rendered":"

Introducci\u00f3n<\/h2>\n

La funci\u00f3n DIAS.LAB.INTL<\/code> en Excel y Google Sheets es extremadamente \u00fatil para calcular el n\u00famero de d\u00edas h\u00e1biles entre dos fechas, considerando fines de semana personalizables y d\u00edas festivos opcionales. Esta funci\u00f3n extiende las capacidades de DIAS.LAB<\/code>, ofreciendo mayor flexibilidad en la definici\u00f3n de los d\u00edas no laborables.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n DIAS.LAB.INTL<\/code> es:<\/p>\n

DIAS.LAB.INTL(fecha_inicial, fecha_final, [fin_de_semana], [festivos])<\/code><\/pre>\n
Donde:<\/p>\n
    \n
  • fecha_inicial<\/strong> y fecha_final<\/strong> son las fechas entre las que se calculan los d\u00edas h\u00e1biles.<\/li>\n
  • fin_de_semana<\/strong> (opcional): Un n\u00famero o cadena que especifica los d\u00edas de la semana que se consideran como fin de semana. Si no se especifica, el s\u00e1bado y domingo se establecen como fin de semana por defecto.<\/li>\n
  • festivos<\/strong> (opcional): Un rango de fechas que ser\u00e1n consideradas como d\u00edas no laborables adem\u00e1s de los fines de semana.<\/li>\n<\/ul>\n
    Por ejemplo, para calcular el n\u00famero de d\u00edas h\u00e1biles entre el 1 de enero y el 31 de enero de 2023, excluyendo los s\u00e1bados y domingos, usar\u00edamos:<\/p>\n
    =DIAS.LAB.INTL(\"01\/01\/2023\", \"31\/01\/2023\")<\/code><\/pre>\n
    Si deseamos cambiar los d\u00edas no laborables a viernes y s\u00e1bado, lo configurar\u00edamos de la siguiente manera:<\/p>\n
    =DIAS.LAB.INTL(\"01\/01\/2023\", \"31\/01\/2023\", 7)<\/code><\/pre>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    C\u00e1lculo de d\u00edas laborables en un proyecto<\/h3>\n
    Supongamos que un proyecto debe iniciar el 15 de marzo y terminar el 15 de septiembre, pero los d\u00edas laborables son de lunes a jueves. Los viernes, s\u00e1bados y domingos son d\u00edas no laborables. No se ha programado ning\u00fan d\u00eda festivo. Para calcular el n\u00famero total de d\u00edas laborables, emplear\u00edamos:<\/p>\n
    =DIAS.LAB.INTL(\"15\/03\/2023\", \"15\/09\/2023\", \"0000111\")<\/code><\/pre>\n
    Aqu\u00ed, \u00ab0000111\u00bb indica que viernes, s\u00e1bado y domingo son d\u00edas no laborables (‘1’).<\/p>\n
    Planificaci\u00f3n de recursos humanos con d\u00edas festivos<\/h3>\n
    En una empresa, para planificar las vacaciones de a\u00f1o nuevo, es necesario calcular los d\u00edas laborables desde el 20 de diciembre hasta el 10 de enero del a\u00f1o siguiente, tomando en cuenta que el 25 de diciembre y el 1 de enero son d\u00edas festivos, y que se trabaja de lunes a viernes:<\/p>\n
    =DIAS.LAB.INTL(\"20\/12\/2023\", \"10\/01\/2024\", 1, {\"25\/12\/2023\", \"01\/01\/2024\"})<\/code><\/pre>\n
    Esto excluye tanto los s\u00e1bados y domingos como los d\u00edas festivos especificados del conteo de d\u00edas laborables.<\/p>\n
    Conclusi\u00f3n<\/h2>\n
    La funci\u00f3n DIAS.LAB.INTL<\/code> es una herramienta poderosa para la planificaci\u00f3n y gesti\u00f3n en contextos que requieren un c\u00e1lculo preciso de d\u00edas laborables, considerando fines de semana personalizados y festivos. Con un entendimiento claro de c\u00f3mo configurar adecuadamente sus par\u00e1metros, esta funci\u00f3n puede ser extremadamente beneficiosa en la administraci\u00f3n de proyectos y recursos humanos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el n\u00famero de todos los d\u00edas laborables entre dos fechas mediante par\u00e1metros para indicar cu\u00e1les y cu\u00e1ntos son d\u00edas de fin de semana<\/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-14107","post","type-post","status-publish","format-standard","hentry","category-fecha-y-hora"],"acf":[],"yoast_head":"\nFunci\u00f3n NETWORKDAYS.INTL (DIAS.LAB.INTL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n NETWORKDAYS.INTL (DIAS.LAB.INTL) 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\/networkdays-intl\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n NETWORKDAYS.INTL (DIAS.LAB.INTL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n NETWORKDAYS.INTL (DIAS.LAB.INTL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/networkdays-intl\/\" \/>\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:54:34+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 NETWORKDAYS.INTL (DIAS.LAB.INTL) 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\/networkdays-intl\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/networkdays-intl\/\",\"name\":\"Funci\u00f3n NETWORKDAYS.INTL (DIAS.LAB.INTL) 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:54:34+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n NETWORKDAYS.INTL (DIAS.LAB.INTL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/networkdays-intl\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/networkdays-intl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/networkdays-intl\/#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.LAB.INTL\"}]},{\"@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 NETWORKDAYS.INTL (DIAS.LAB.INTL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n NETWORKDAYS.INTL (DIAS.LAB.INTL) 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\/networkdays-intl\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n NETWORKDAYS.INTL (DIAS.LAB.INTL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n NETWORKDAYS.INTL (DIAS.LAB.INTL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/networkdays-intl\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:54:34+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n NETWORKDAYS.INTL (DIAS.LAB.INTL) 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\/networkdays-intl\/","url":"https:\/\/functiontranslator.com\/es\/networkdays-intl\/","name":"Funci\u00f3n NETWORKDAYS.INTL (DIAS.LAB.INTL) 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:54:34+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n NETWORKDAYS.INTL (DIAS.LAB.INTL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/networkdays-intl\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/networkdays-intl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/networkdays-intl\/#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.LAB.INTL"}]},{"@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\/14107","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=14107"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14107\/revisions"}],"predecessor-version":[{"id":30199,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14107\/revisions\/30199"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}