{"id":27653,"date":"2026-03-28T13:30:00","date_gmt":"2026-03-28T18:30:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=27653"},"modified":"2026-03-28T13:18:49","modified_gmt":"2026-03-28T18:18:49","slug":"calcular-dias-habiles-en-excel","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/","title":{"rendered":"Calcular d\u00edas h\u00e1biles en Excel"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-calcular-dias-habiles-en-excel\">Calcular d\u00edas h\u00e1biles en Excel<\/h1>\n\n\n\n<p>Dominar las fechas es fundamental en cualquier entorno administrativo. Ya sea que necesites liquidar una obra o proyectar cu\u00e1ndo termina un periodo de vacaciones, saber <strong>calcular d\u00edas h\u00e1biles en Excel<\/strong> te ahorrar\u00e1 horas de trabajo manual y evitar\u00e1 errores costosos.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Calcula d\u00edas laborales en Excel para n\u00f3mina, obras y vacaciones f\u00e1cilmente.\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/d1L6Xoxw7lM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">En este tutorial, aprender\u00e1s a usar las funciones m\u00e1s potentes y actualizadas para gestionar calendarios laborales, incluyendo c\u00f3mo tratar los s\u00e1bados y los d\u00edas festivos de tu pa\u00eds de forma personalizada.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-629087f1\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\" style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"h-descargar-material-de-apoyo\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left\">\u00bfListo para poner en pr\u00e1ctica el tutorial? Descarga el \u00abmaterial de apoyo\u00bb y trabaja con el mismo archivo que usamos en el video.<\/p>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-c46826\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-09e341 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Material-de-Apoyo.xlsx\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" fill=\"currentColor\" viewBox=\"0 0 24 24\">\n  <path d=\"M2 19v-4a1 1 0 1 1 2 0v4c0 .548.452 1 1 1h14a1 1 0 0 0 1-1v-4a1 1 0 1 1 2 0v4a3 3 0 0 1-3 3H5c-1.652 0-3-1.348-3-3Z\"\/>\n  <path d=\"M12 1.5a1 1 0 0 0-1 1V8H7a1 1 0 0 0-.707 1.707l5 5a1 1 0 0 0 1.414 0l5-5A1 1 0 0 0 17 8h-4V2.5a1 1 0 0 0-1-1Z\"\/>\n<\/svg>\n<\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-0e701958\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-4a223f94\"><h2 class=\"uagb-heading-text\">Paso 1: Contar d\u00edas entre dos fechas (Liquidaci\u00f3n de obra)<\/h2><\/div>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-9838d95b wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><a class=\"\" href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos-gratis\/excel-curso-basico-intermedio\/\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/vlcsnap-2026-03-28-12h15m52s117.png ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/vlcsnap-2026-03-28-12h15m52s117.png 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/vlcsnap-2026-03-28-12h15m52s117.png 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/vlcsnap-2026-03-28-12h15m52s117.png\" alt=\"Men\u00fa de selecci\u00f3n de fines de semana en la funci\u00f3n DIAS.LAB.INTL de Excel.\" class=\"uag-image-27658\" width=\"3368\" height=\"1270\" title=\"configuracion-dias-laborales-personalizados-excel\" loading=\"lazy\" role=\"img\"\/><\/a><\/figure><\/div>\n\n\n\n<p id=\"p-rc_83db89d78af74cd1-65\" style=\"margin-top:var(--wp--preset--spacing--50)\">El primer escenario ocurre cuando tienes una fecha de inicio y una de fin, y necesitas saber cu\u00e1ntos d\u00edas se trabajaron realmente. <sup><\/sup><\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Selecciona la celda de resultado:<\/strong> Donde deseas ver el n\u00famero total de d\u00edas. <\/li>\n\n\n\n<li><strong>Usa la funci\u00f3n avanzada:<\/strong> Escribe <code>=DIAS.LAB.INTL(<\/code>. <\/li>\n\n\n\n<li><strong>Define los argumentos:<\/strong>\n<ul class=\"wp-block-list\">\n<li><strong>Fecha inicial:<\/strong> Haz clic en la celda con la fecha de comienzo.<\/li>\n\n\n\n<li><strong>Fecha final:<\/strong> Selecciona la celda con la fecha de cierre.<\/li>\n\n\n\n<li><strong>Fin de semana:<\/strong> Aqu\u00ed Excel te permite elegir qu\u00e9 d\u00edas se descansa. Por ejemplo, si en tu pa\u00eds o empresa se trabaja el s\u00e1bado, selecciona la opci\u00f3n \u00abSolo domingo\u00bb.<\/li>\n\n\n\n<li><strong>Festivos:<\/strong> Selecciona el rango de celdas donde tengas anotados los d\u00edas festivos de tu pa\u00eds. <\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-d27ad14e\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Paso 2: Sumar d\u00edas laborales a una fecha (C\u00e1lculo de vacaciones)<\/h2>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-34792e67 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/vlcsnap-2026-03-28-12h20m06s315.png ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/vlcsnap-2026-03-28-12h20m06s315.png 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/vlcsnap-2026-03-28-12h20m06s315.png 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/vlcsnap-2026-03-28-12h20m06s315.png\" alt=\"Selecci\u00f3n de rango de celdas con fechas de festivos en Excel.\" class=\"uag-image-27660\" width=\"3338\" height=\"859\" title=\"seleccion-rango-festivos-colombia-excel\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p id=\"p-rc_83db89d78af74cd1-69\" style=\"margin-top:var(--wp--preset--spacing--50)\">A diferencia del paso anterior, aqu\u00ed buscamos una fecha futura. Por ejemplo, si un empleado sale a vacaciones por 15 d\u00edas h\u00e1biles, \u00bfqu\u00e9 d\u00eda debe regresar? <sup><\/sup><\/p>\n\n\n\n<p id=\"p-rc_83db89d78af74cd1-70\">Para esto, no usamos la funci\u00f3n \u00abd\u00edas\u00bb (en plural), sino la funci\u00f3n en singular: <code>DIA.LAB.INTL<\/code>. <sup><\/sup><\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Escribe la f\u00f3rmula:<\/strong> <code>=DIA.LAB.INTL(<\/code>. <\/li>\n\n\n\n<li><strong>Ingresa los datos:<\/strong>\n<ul class=\"wp-block-list\">\n<li><strong>Fecha inicial:<\/strong> El d\u00eda que inician las vacaciones o el env\u00edo.<\/li>\n\n\n\n<li><strong>D\u00edas:<\/strong> El n\u00famero de d\u00edas h\u00e1biles que quieres sumar (ej. 15).<\/li>\n\n\n\n<li><strong>Fin de semana:<\/strong> Elige el esquema laboral (ej. S\u00e1bado y Domingo).<\/li>\n\n\n\n<li><strong>Festivos:<\/strong> Marca la lista de d\u00edas no laborales. <\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-6ee3e1a4\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Consejos para optimizar tus hojas de c\u00e1lculo<\/h2>\n\n\n\n<p id=\"p-rc_83db89d78af74cd1-73\">Al <strong>contar d\u00edas laborales en Excel<\/strong>, es vital mantener una lista de festivos actualizada. <sup><\/sup><sup><\/sup><sup><\/sup>Puedes descargar plantillas que ya incluyen los calendarios de los pa\u00edses m\u00e1s comunes para asegurar que tu c\u00e1lculo de <strong>d\u00edas h\u00e1biles en Excel<\/strong> sea 100% preciso. <sup><\/sup><\/p>\n\n\n\n<p id=\"p-rc_83db89d78af74cd1-74\">Si est\u00e1s utilizando una versi\u00f3n antigua, recuerda que estas funciones est\u00e1n disponibles desde Excel 2010. Si necesitas actualizar tu herramienta, considera opciones de <a href=\"https:\/\/dostin.pro\/keysworlds\" target=\"_blank\" rel=\"noreferrer noopener\">pago \u00fanico<\/a> para evitar suscripciones mensuales. <\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-63e33197\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p id=\"p-rc_83db89d78af74cd1-75\">Saber <strong>calcular d\u00edas h\u00e1biles en Excel<\/strong> es una habilidad que marca la diferencia en la gesti\u00f3n de proyectos y n\u00f3minas. <sup><\/sup>Ya sea usando <code>DIAS.LAB.INTL<\/code> para obtener un recuento o <code>DIA.LAB.INTL<\/code> para proyectar fechas, ahora tienes el control total sobre el tiempo en tus hojas de c\u00e1lculo. <sup><\/sup><\/p>\n\n\n\n<p id=\"p-rc_83db89d78af74cd1-76\">Si quieres profundizar en el dise\u00f1o de herramientas para tu web, te recomiendo visitar mi <a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos-gratis\/curso-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">curso de WordPress<\/a> o aprender a organizar mejor tus datos con <a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos-gratis\/curso-excel-avanzado\/\" target=\"_blank\" rel=\"noreferrer noopener\">macros en Excel<\/a>. <\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-b3505a43\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\" style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"h-descargar-material-de-apoyo-0\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left\">\u00bfListo para poner en pr\u00e1ctica el tutorial? Descarga el \u00abmaterial de apoyo\u00bb y trabaja con el mismo archivo que usamos en el video.<\/p>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-586552\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-63eeb4 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Material-de-Apoyo.xlsx\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" fill=\"currentColor\" viewBox=\"0 0 24 24\">\n  <path d=\"M2 19v-4a1 1 0 1 1 2 0v4c0 .548.452 1 1 1h14a1 1 0 0 0 1-1v-4a1 1 0 1 1 2 0v4a3 3 0 0 1-3 3H5c-1.652 0-3-1.348-3-3Z\"\/>\n  <path d=\"M12 1.5a1 1 0 0 0-1 1V8H7a1 1 0 0 0-.707 1.707l5 5a1 1 0 0 0 1.414 0l5-5A1 1 0 0 0 17 8h-4V2.5a1 1 0 0 0-1-1Z\"\/>\n<\/svg>\n<\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-379f9b74\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Preguntas Frecuentes<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-130235a8 uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-99a52b9f \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfCu\u00e1l es la diferencia entre DIAS.LAB y DIAS.LAB.INTL?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>La funci\u00f3n est\u00e1ndar asume que el fin de semana es siempre s\u00e1bado y domingo. La versi\u00f3n INTL te permite personalizar qu\u00e9 d\u00edas se descansan, lo cual es vital para <strong>calcular d\u00edas h\u00e1biles en Excel<\/strong> en sectores como la construcci\u00f3n o el comercio.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-8b70405f \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfC\u00f3mo incluyo los festivos de mi pa\u00eds?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Solo debes crear una lista con las fechas de los festivos en una columna aparte y seleccionarla como el \u00faltimo argumento de la funci\u00f3n.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-3e27db99 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfQu\u00e9 pasa si el resultado me sale un n\u00famero extra\u00f1o en lugar de una fecha?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Aseg\u00farate de cambiar el formato de la celda de \u00abGeneral\u00bb o \u00abN\u00famero\u00bb a \u00abFecha corta\u00bb.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-590c61dc \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPuedo usar estas funciones en Excel para Mac?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, funcionan exactamente igual tanto en Windows como en Mac y en versiones de Office 2021.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-392ef9f7 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfD\u00f3nde puedo conseguir la lista de festivos hasta 2028?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes descargar el archivo base del tutorial desde los recursos oficiales de Dostin Hurtado para tener los datos actualizados.<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Calcular d\u00edas h\u00e1biles en Excel Dominar las fechas es fundamental en cualquier entorno administrativo. Ya sea que necesites liquidar una [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":27654,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[52],"tags":[562,225,277,539,570,486],"class_list":["post-27653","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriales-excel","tag-curso","tag-excel","tag-gratis","tag-gratuito","tag-recomendado","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Calcular d\u00edas h\u00e1biles en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende a calcular d\u00edas h\u00e1biles en Excel y sumar d\u00edas laborales a una fecha usando DIAS.LAB.INTL. Gu\u00eda para principiantes con festivos\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calcular d\u00edas h\u00e1biles en Excel - Dostin Hurtado\" \/>\n<meta property=\"og:description\" content=\"Aprende a calcular d\u00edas h\u00e1biles en Excel y sumar d\u00edas laborales a una fecha usando DIAS.LAB.INTL. Gu\u00eda para principiantes con festivos\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-28T18:30:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin Hurtado\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/calcular-dias-habiles-en-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/calcular-dias-habiles-en-excel\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/4cccf51633cffba81a46211a8ab89daa\"},\"headline\":\"Calcular d\u00edas h\u00e1biles en Excel\",\"datePublished\":\"2026-03-28T18:30:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/calcular-dias-habiles-en-excel\\\/\"},\"wordCount\":590,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/calcular-dias-habiles-en-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif\",\"keywords\":[\"Curso\",\"Excel\",\"Gratis\",\"Gratuito\",\"recomendado\",\"Tutorial\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/calcular-dias-habiles-en-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/calcular-dias-habiles-en-excel\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/calcular-dias-habiles-en-excel\\\/\",\"name\":\"Calcular d\u00edas h\u00e1biles en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/calcular-dias-habiles-en-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/calcular-dias-habiles-en-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif\",\"datePublished\":\"2026-03-28T18:30:00+00:00\",\"description\":\"Aprende a calcular d\u00edas h\u00e1biles en Excel y sumar d\u00edas laborales a una fecha usando DIAS.LAB.INTL. Gu\u00eda para principiantes con festivos\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/calcular-dias-habiles-en-excel\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/calcular-dias-habiles-en-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/calcular-dias-habiles-en-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif\",\"width\":500,\"height\":375,\"caption\":\"aprende a calcular d\u00edas laborales en Excel en segundos\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/calcular-dias-habiles-en-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Calcular d\u00edas h\u00e1biles en Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/4cccf51633cffba81a46211a8ab89daa\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/275749aad03534aea916e76323728243.jpg?ver=1782136890\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/275749aad03534aea916e76323728243.jpg?ver=1782136890\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/275749aad03534aea916e76323728243.jpg?ver=1782136890\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/daniel\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calcular d\u00edas h\u00e1biles en Excel - Dostin Hurtado","description":"Aprende a calcular d\u00edas h\u00e1biles en Excel y sumar d\u00edas laborales a una fecha usando DIAS.LAB.INTL. Gu\u00eda para principiantes con festivos","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:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Calcular d\u00edas h\u00e1biles en Excel - Dostin Hurtado","og_description":"Aprende a calcular d\u00edas h\u00e1biles en Excel y sumar d\u00edas laborales a una fecha usando DIAS.LAB.INTL. Gu\u00eda para principiantes con festivos","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/","og_site_name":"Dostin Hurtado","article_published_time":"2026-03-28T18:30:00+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/4cccf51633cffba81a46211a8ab89daa"},"headline":"Calcular d\u00edas h\u00e1biles en Excel","datePublished":"2026-03-28T18:30:00+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/"},"wordCount":590,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif","keywords":["Curso","Excel","Gratis","Gratuito","recomendado","Tutorial"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/","name":"Calcular d\u00edas h\u00e1biles en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif","datePublished":"2026-03-28T18:30:00+00:00","description":"Aprende a calcular d\u00edas h\u00e1biles en Excel y sumar d\u00edas laborales a una fecha usando DIAS.LAB.INTL. Gu\u00eda para principiantes con festivos","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif","width":500,"height":375,"caption":"aprende a calcular d\u00edas laborales en Excel en segundos"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calcular-dias-habiles-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Calcular d\u00edas h\u00e1biles en Excel"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"]},{"@type":"Person","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/4cccf51633cffba81a46211a8ab89daa","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1782136890","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1782136890","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1782136890","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/daniel\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif",500,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04-300x225.avif",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif",500,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif",500,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif",500,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif",500,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif",500,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif",500,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif",500,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif",500,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04-400x375.avif",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04.avif",500,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/03\/Calcular-Dias-Laborales-en-Excel-miniatura-04-100x100.avif",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/daniel\/"},"uagb_comment_info":0,"uagb_excerpt":"Calcular d\u00edas h\u00e1biles en Excel Dominar las fechas es fundamental en cualquier entorno administrativo. Ya sea que necesites liquidar una [&hellip;]","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/27653","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=27653"}],"version-history":[{"count":5,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/27653\/revisions"}],"predecessor-version":[{"id":27661,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/27653\/revisions\/27661"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/27654"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=27653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=27653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=27653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}