{"id":21157,"date":"2024-03-08T12:30:00","date_gmt":"2024-03-08T17:30:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=21157"},"modified":"2025-04-09T15:17:04","modified_gmt":"2025-04-09T20:17:04","slug":"calculos-con-fechas-en-excel","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/","title":{"rendered":"C\u00e1lculos con fechas en Excel"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-calculos-con-fechas-en-excel-guia-completa-para-sumar-restar-y-comparar\">C\u00e1lculos con Fechas en Excel: Gu\u00eda Completa para Sumar, Restar y Comparar<\/h2>\n\n\n\n<p>Las fechas en Excel pueden parecer complicadas al principio, pero en realidad, Excel las maneja como n\u00fameros, lo que permite realizar c\u00e1lculos f\u00e1cilmente. En esta gu\u00eda, aprender\u00e1s todo sobre los <strong>C\u00e1lculos con Fechas en Excel<\/strong>, incluyendo c\u00f3mo sumar, restar y comparar fechas, adem\u00e1s de personalizar su formato y utilizar funciones clave para optimizar tu trabajo.<\/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=\"C\u00f3mo Hacer C\u00e1lculos con Fechas en Excel: Sumar, Restar, Comparar, formatos y Funciones\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/JDFA0Z2Wndc?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<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-6af1f3\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-fec432 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Material-de-Apoyo-fechas-en-excel.zip\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 48 41.6\"><g><path d=\"M30.777 0a17.252 17.252 0 0 0-15.969 10.734 12.026 12.026 0 1 0-5.2 23.479 2.084 2.084 0 0 0 .413.042 2.051 2.051 0 0 0 .409-4.06 7.924 7.924 0 0 1 1.6-15.686 7.84 7.84 0 0 1 3.231.691l2.2.986.617-2.333a13.132 13.132 0 0 1 25.821 3.372 12.993 12.993 0 0 1-4.169 9.6 2.052 2.052 0 0 0 2.8 3A17.229 17.229 0 0 0 30.779.002\"><\/path><path d=\"M34.188 29.466h-5.18V15.578a1.164 1.164 0 0 0-1.164-1.164h-3.94a1.164 1.164 0 0 0-1.164 1.164v13.888h-5.18a1.164 1.164 0 0 0-.888 1.917l8.314 9.8a1.164 1.164 0 0 0 1.775 0l8.315-9.8a1.164 1.164 0 0 0-.888-1.917\"><\/path><\/g><\/svg><\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-como-funcionan-las-fechas-en-excel\">\u00bfC\u00f3mo Funcionan las Fechas en Excel?<\/h2>\n\n\n\n<p>En Excel, cada fecha se almacena como un n\u00famero secuencial. Por ejemplo, el 1 de enero de 2024 equivale a un n\u00famero espec\u00edfico. Esto permite que puedas sumar o restar d\u00edas como si fueran simples operaciones matem\u00e1ticas.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">C\u00e1lculos con Fechas en Excel: Sumar y Restar D\u00edas<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Sumar D\u00edas a una Fecha en Excel<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"a9bad6\" data-has-transparency=\"true\" style=\"--dominant-color: #a9bad6;\" fetchpriority=\"high\" decoding=\"async\" width=\"569\" height=\"100\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-png.avif\" alt=\"Tabla en Excel que calcula la fecha de finalizaci\u00f3n de un contrato sumando 60 d\u00edas a la fecha de inicio.\" class=\"wp-image-24695 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-png.avif 569w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-300x53.avif 300w\" sizes=\"(max-width: 569px) 100vw, 569px\" \/><\/figure>\n\n\n\n<p>Si deseas agregar d\u00edas a una fecha, solo debes utilizar una f\u00f3rmula sencilla:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=A1 + 60<\/code><\/pre>\n\n\n\n<p>Si en la celda A1 tienes el 30 de marzo de 2024, al sumar 60 d\u00edas, Excel mostrar\u00e1 el 29 de mayo de 2024.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Restar D\u00edas a una Fecha en Excel<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"c7d1de\" data-has-transparency=\"true\" style=\"--dominant-color: #c7d1de;\" decoding=\"async\" width=\"580\" height=\"64\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-1-png.avif\" alt=\" Tabla en Excel que calcula la fecha de inicio de un per\u00edodo restando 60 d\u00edas a la fecha final.\" class=\"wp-image-24696 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-1-png.avif 580w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-1-300x33.avif 300w\" sizes=\"(max-width: 580px) 100vw, 580px\" \/><\/figure>\n\n\n\n<p>Para calcular la fecha de inicio de un contrato que dura 60 d\u00edas, puedes usar:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=A1 - 60<\/code><\/pre>\n\n\n\n<p>Si en A1 tienes la fecha final del contrato, Excel calcular\u00e1 autom\u00e1ticamente la fecha de inicio.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Formatos de Fechas en Excel<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"eceef0\" data-has-transparency=\"true\" decoding=\"async\" width=\"685\" height=\"621\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-2-png.avif\" alt=\"\" class=\"wp-image-24697 has-transparency\" style=\"--dominant-color: #eceef0; width:420px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-2-png.avif 685w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-2-300x272.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-2-600x544.avif 600w\" sizes=\"(max-width: 685px) 100vw, 685px\" \/><\/figure>\n\n\n\n<p>Excel permite cambiar la forma en que se muestran las fechas sin alterar su valor. Para modificar el formato:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Selecciona la celda con la fecha.<\/li>\n\n\n\n<li>Presiona <code>Ctrl + 1<\/code> o haz clic derecho y elige \u00abFormato de celdas\u00bb.<\/li>\n\n\n\n<li>En la pesta\u00f1a \u00abN\u00famero\u00bb, selecciona \u00abFecha\u00bb y elige el formato deseado.<\/li>\n<\/ol>\n\n\n\n<p>Si necesitas un formato personalizado, puedes ir a la secci\u00f3n \u00abPersonalizada\u00bb e ingresar un c\u00f3digo como:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>dd-mm-yyyy<\/code><\/pre>\n\n\n\n<p>Esto mostrar\u00e1 la fecha con d\u00eda, mes y a\u00f1o separados por guiones.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">C\u00e1lculos con Fechas en Excel: Comparar Fechas<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"b1bcd2\" data-has-transparency=\"true\" style=\"--dominant-color: #b1bcd2;\" loading=\"lazy\" decoding=\"async\" width=\"626\" height=\"90\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-3-png.avif\" alt=\"\" class=\"wp-image-24698 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-3-png.avif 626w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-3-300x43.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-3-600x86.avif 600w\" sizes=\"(max-width: 626px) 100vw, 626px\" \/><\/figure>\n\n\n\n<p>Para verificar si un producto ha caducado, podemos usar la funci\u00f3n <code>SI<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SI(A1&gt;B1, \"Vencido\", \"Bueno\")<\/code><\/pre>\n\n\n\n<p>Si <code>A1<\/code> es la fecha actual y <code>B1<\/code> es la fecha de vencimiento, Excel determinar\u00e1 si el producto est\u00e1 vencido o no.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Operadores de Comparaci\u00f3n en Fechas<\/h3>\n\n\n\n<p><code>&gt;<\/code> Mayor que<\/p>\n\n\n\n<p><code>&lt;<\/code> Menor que<\/p>\n\n\n\n<p><code>&gt;=<\/code> Mayor o igual que<\/p>\n\n\n\n<p><code>&lt;=<\/code> Menor o igual que<\/p>\n\n\n\n<p><code>&lt;&gt;<\/code> Diferente de<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Funciones de Fecha en Excel<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Obtener la Fecha Actual con HOY y AHORA<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"b3c0d6\" data-has-transparency=\"true\" style=\"--dominant-color: #b3c0d6;\" loading=\"lazy\" decoding=\"async\" width=\"574\" height=\"92\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-4-png.avif\" alt=\"\" class=\"wp-image-24699 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-4-png.avif 574w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-4-300x48.avif 300w\" sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>HOY()<\/code>: Devuelve la fecha actual sin hora.<\/li>\n\n\n\n<li><code>AHORA()<\/code>: Devuelve la fecha y hora actual.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Extraer D\u00eda, Mes y A\u00f1o de una Fecha<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"b0bed6\" data-has-transparency=\"true\" style=\"--dominant-color: #b0bed6;\" loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"94\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-5-png.avif\" alt=\"\" class=\"wp-image-24700 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-5-png.avif 570w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/image-5-300x49.avif 300w\" sizes=\"(max-width: 570px) 100vw, 570px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>DIA(A1)<\/code>: Extrae el d\u00eda de la fecha.<\/li>\n\n\n\n<li><code>MES(A1)<\/code>: Extrae el mes de la fecha.<\/li>\n\n\n\n<li><code>A\u00d1O(A1)<\/code>: Extrae el a\u00f1o de la fecha.<\/li>\n<\/ul>\n\n\n\n<p>\ud83d\udd34 <strong>\u00a1No pagues de m\u00e1s por tu software!<\/strong> En <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\" target=\"_blank\" rel=\"noreferrer noopener\">Keysfan<\/a><\/strong> puedes conseguir licencias originales de <strong>Windows y Office<\/strong> a precios incre\u00edblemente bajos. \ud83d\udcbb\u2728 Adem\u00e1s, con el c\u00f3digo de descuento <strong>DH66<\/strong>, obtendr\u00e1s un <strong>ahorro extra<\/strong> en tu compra. \ud83d\udcb0\ud83d\udd25<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Trabajar con fechas en Excel es m\u00e1s f\u00e1cil de lo que parece. Con las funciones adecuadas y un buen manejo de los formatos, puedes realizar c\u00e1lculos precisos y automatizar tareas. Si tienes dudas, d\u00e9jalas en los comentarios y te ayudaremos a resolverlas en futuros tutoriales.<\/p>\n\n\n\n<p>\ud83d\udce2\u00a1Mejora tu productividad en Excel con la <strong>Funci\u00f3n SI<\/strong>! \ud83d\udcca Si a\u00fan no dominas esta poderosa herramienta, es el momento perfecto para aprender. En el <strong><a href=\"https:\/\/dostinhurtado.com\/site\/cursos\/excel-curso-basico-intermedio\/funcion-si-basica\/\" target=\"_blank\" rel=\"noreferrer noopener\">Cap\u00edtulo 3 del Curso de Excel<\/a><\/strong>, descubrir\u00e1s c\u00f3mo utilizar la <strong>Funci\u00f3n SI b\u00e1sica<\/strong> para tomar decisiones automatizadas en tus hojas de c\u00e1lculo. No pierdas la oportunidad de optimizar tu trabajo y ahorrar tiempo con f\u00f3rmulas inteligentes.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-preguntas-frecuentes-faq\">Preguntas Frecuentes (FAQ)<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-98c3ba43 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-8daa3467 \" 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\">\u00bfC\u00f3mo restar dos fechas en Excel?<\/span><\/div><div class=\"uagb-faq-content\"><p>Solo debes usar una f\u00f3rmula simple:<br><code><strong>=A2 - A1<\/strong><\/code><br>Esto te dar\u00e1 el n\u00famero de d\u00edas entre ambas fechas.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-99297461 \" 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\">\u00bfC\u00f3mo cambiar el formato de fecha en Excel?<\/span><\/div><div class=\"uagb-faq-content\"><p>Ve a \u00abFormato de celdas\u00bb (<code>Ctrl + 1<\/code>), selecciona \u00abFecha\u00bb y elige el formato deseado.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-50970a74 \" 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\">\u00bfC\u00f3mo saber si una fecha ya pas\u00f3 en Excel?<\/span><\/div><div class=\"uagb-faq-content\"><p>Usa la funci\u00f3n <code>SI<\/code>:<br>=SI(A1&lt;HOY(), \u00abFecha pasada\u00bb, \u00abFecha futura\u00bb)<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-87d2c8a4 \" 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\">\u00bfC\u00f3mo calcular la diferencia en meses o a\u00f1os entre dos fechas?<\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes usar la funci\u00f3n <code>SIFECHA<\/code>:<br><code>=SIFECHA(A1, A2, \"M\") \/\/ Devuelve la diferencia en meses =SIFECHA(A1, A2, \"Y\") \/\/ Devuelve la diferencia en a\u00f1os<\/code><br>Esto te permite saber cu\u00e1ntos meses o a\u00f1os han pasado entre dos fechas..<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-ba600e56 \" 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\">\u00bfPor qu\u00e9 Excel no reconoce una fecha correctamente?<\/span><\/div><div class=\"uagb-faq-content\"><p>Si Excel no reconoce una fecha, puede deberse a un formato incorrecto. Verifica que la celda tenga el formato de fecha correcto (<code>Ctrl + 1 &gt; Fecha<\/code>) o usa la funci\u00f3n <code>FECHANUMERO<\/code> para convertir un texto en fecha.<\/p><\/div><\/div><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-\"><\/h2>\n","protected":false},"excerpt":{"rendered":"<p>Transforma tu uso de Excel aprendiendo c\u00e1lculos con fechas. Suma y resta fechas f\u00e1cilmente y optimiza tus tareas.<\/p>\n","protected":false},"author":4,"featured_media":21159,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"video","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":[2741,277,2251,1812,366,2734,2819],"class_list":["post-21157","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-excel-tips","tag-gratis","tag-licencia-de-office","tag-microsoft-excel","tag-office-365","tag-trucos-excel","tag-tutorial-excel","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>C\u00e1lculos con fechas en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Transforma tu uso de Excel aprendiendo c\u00e1lculos con fechas. Suma y resta fechas f\u00e1cilmente y optimiza tus tareas.\" \/>\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\/calculos-con-fechas-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1lculos con fechas en Excel\" \/>\n<meta property=\"og:description\" content=\"Transforma tu uso de Excel aprendiendo c\u00e1lculos con fechas. Suma y resta fechas f\u00e1cilmente y optimiza tus tareas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-08T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-09T20:17:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg\" \/>\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=\"4 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\/calculos-con-fechas-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2\"},\"headline\":\"C\u00e1lculos con fechas en Excel\",\"datePublished\":\"2024-03-08T17:30:00+00:00\",\"dateModified\":\"2025-04-09T20:17:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/\"},\"wordCount\":621,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg\",\"keywords\":[\"Excel Tips\",\"Gratis\",\"licencia de office\",\"Microsoft Excel\",\"Office 365\",\"Trucos Excel\",\"Tutorial Excel\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/\",\"url\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/\",\"name\":\"C\u00e1lculos con fechas en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg\",\"datePublished\":\"2024-03-08T17:30:00+00:00\",\"dateModified\":\"2025-04-09T20:17:04+00:00\",\"description\":\"Transforma tu uso de Excel aprendiendo c\u00e1lculos con fechas. Suma y resta fechas f\u00e1cilmente y optimiza tus tareas.\",\"breadcrumb\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#primaryimage\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg\",\"width\":500,\"height\":375,\"caption\":\"Fechas en Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/dostinhurtado.com\/site\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1lculos con fechas 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\/19f7f0caccebab406700992c37c9583d\"},\"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\/19f7f0caccebab406700992c37c9583d\",\"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\/8ce550788514b771f2fd0ab59d1694f2\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\/\/dostinhurtado.com\/site\/author\/moderador\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1lculos con fechas en Excel - Dostin Hurtado","description":"Transforma tu uso de Excel aprendiendo c\u00e1lculos con fechas. Suma y resta fechas f\u00e1cilmente y optimiza tus tareas.","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\/calculos-con-fechas-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"C\u00e1lculos con fechas en Excel","og_description":"Transforma tu uso de Excel aprendiendo c\u00e1lculos con fechas. Suma y resta fechas f\u00e1cilmente y optimiza tus tareas.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/","og_site_name":"Dostin Hurtado","article_published_time":"2024-03-08T17:30:00+00:00","article_modified_time":"2025-04-09T20:17:04+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2"},"headline":"C\u00e1lculos con fechas en Excel","datePublished":"2024-03-08T17:30:00+00:00","dateModified":"2025-04-09T20:17:04+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/"},"wordCount":621,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg","keywords":["Excel Tips","Gratis","licencia de office","Microsoft Excel","Office 365","Trucos Excel","Tutorial Excel"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/","name":"C\u00e1lculos con fechas en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg","datePublished":"2024-03-08T17:30:00+00:00","dateModified":"2025-04-09T20:17:04+00:00","description":"Transforma tu uso de Excel aprendiendo c\u00e1lculos con fechas. Suma y resta fechas f\u00e1cilmente y optimiza tus tareas.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg","width":500,"height":375,"caption":"Fechas en Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/calculos-con-fechas-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"C\u00e1lculos con fechas 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\/19f7f0caccebab406700992c37c9583d"},"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\/19f7f0caccebab406700992c37c9583d","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\/8ce550788514b771f2fd0ab59d1694f2","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg",500,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05-300x225.jpg",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg",500,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg",500,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg",500,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg",500,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg",500,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg",500,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg",500,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg",500,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05-400x375.jpg",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05.jpg",500,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/03\/Fechas-en-Excel-Sumar-Restar-Comparar-y-Funciones-miniatura-05-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":0,"uagb_excerpt":"Transforma tu uso de Excel aprendiendo c\u00e1lculos con fechas. Suma y resta fechas f\u00e1cilmente y optimiza tus tareas.","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/21157","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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=21157"}],"version-history":[{"count":3,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/21157\/revisions"}],"predecessor-version":[{"id":25275,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/21157\/revisions\/25275"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/21159"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=21157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=21157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=21157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}