{"id":45941,"date":"2020-04-21T22:27:25","date_gmt":"2020-04-22T04:27:25","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=45941"},"modified":"2025-01-05T22:08:19","modified_gmt":"2025-01-06T04:08:19","slug":"calcular-semanas-con-dos-fechas","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/calcular-semanas-con-dos-fechas.html","title":{"rendered":"Calcular semanas entre dos fechas de a\u00f1os diferentes"},"content":{"rendered":"<h1 style=\"text-align: center;\">Calcular semanas entre dos fechas de a\u00f1os diferentes<\/h1>\n<p style=\"\">Estas listo para Calcular semanas entre dos fechas de a\u00f1os diferentes?<\/p>\n<p><span><img decoding=\"async\" alt=\"Calcular semanas\" data-id=\"45945\" width=\"492\" data-init-width=\"500\" height=\"212\" data-init-height=\"215\" title=\"Calcular el numero de semanas a\u00f1os diferentes\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Calcular-el-numero-de-semanas-a\u00f1os-diferentes.png\" data-link-wrap=\"true\" data-width=\"492\" data-height=\"212\" style=\"aspect-ratio: auto 500 \/ 215;\"><\/span><\/p>\n<p style=\"\">Antes de compartirte el truco de como Extraer el Numero de semanas entre dos fechas de a\u00f1os diferentes.<\/p>\n<p style=\"\">Quiero compartirte por que decid\u00ed escribir este articulo.<\/p>\n<p style=\"\">Actualmente tenemos un articulo, tambi\u00e9n explicado en video, llamado <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/numero-de-semana\" target=\"_blank\" style=\"outline: none;\"><em><strong>Como extraer el numero de semana entre dos fechas<\/strong><\/em><\/a>.<\/p>\n<p style=\"\">Usuarios del blog y nuestros seguidores de YouTube, nos hicieron la pregunta en reiteradas ocasiones:<\/p>\n<blockquote><p><strong>\u00abComo puedo calcular el numero de semana entre dos fechas de a\u00f1os diferentes\u00bb.<\/strong><\/p><\/blockquote>\n<p>Y hoy decidimos escribir la respuesta detalladamente paso a paso.<\/p>\n<h2 style=\"text-align: center;\">Pasos para Calcular semanas entre dos fechas de a\u00f1os diferentes<\/h2>\n<p style=\"\">Para hacer c\u00e1lculos en Excel lo primero que debes de tomar en cuenta es la funci\u00f3n a utilizar en las formulas.<\/p>\n<p style=\"\">En este caso, vamos a calcular semanas entre dos fechas, por lo tanto, vamos a utilizar la funci\u00f3n NUM.DE.SEMANA.<\/p>\n<p style=\"\">Ahora que ya sabes que funci\u00f3n vas a utilizar en tus formulas, el segundo paso es conocer la sintaxis de la funci\u00f3n.<\/p>\n<p style=\"\">Entonces veamos:&nbsp;<\/p>\n<h3 style=\"text-align: center;\">Sintaxis de la Funci\u00f3n NUM.DE.SEMANA<\/h3>\n<p style=\"\">A continuaci\u00f3n te dejo la sintaxis de la funci\u00f3n NUM.DE.SEMANA:<\/p>\n<blockquote style=\"\"><p><em><strong>=NUM.DE.SEMANA(n\u00famero_serie;[tipo_devuelto])<\/strong><\/em><\/p><\/blockquote>\n<p style=\"\">Donde cada componente de la sintaxis tiene un significado:<\/p>\n<ul>\n<li style=\"\">N\u00famero_serie: Es el c\u00f3digo de fecha-hora utilizado por microsoft Excel para los c\u00e1lculos de fecha y hora.<\/li>\n<li style=\"\">Tipo_devuelto: Es un n\u00famero (1 o 2) que determina el tipo de valor devuelto.<\/li>\n<\/ul>\n<p>Listo, ahora si estas preparado para comenzar a crear la formula para calcular semanas entre dos fechas.<\/p>\n<p style=\"\">Para comenzar te invito a que descargues el archivo de practica:<\/p>\n<p><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2016\/08\/Ejemplo-Numero-de-Semana-en-Blanco-1.xlsx\" target=\"_blank\"><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2016\/08\/Ejemplo-Numero-de-Semana-en-Blanco-1.xlsx\" target=\"_blank\" style=\"outline: none;\"><em><strong>Haz clic para descargar el archivo excel<\/strong><\/em><\/a><\/p>\n<p style=\"\">Pulsa clic en el enlace o bien en la imagen de excel para descargar el archivo de practica.<\/p>\n<p style=\"\">Dentro del archivo, escribe las siguientes fechas, tal a como se muestra en la imagen:<\/p>\n<p><span><img decoding=\"async\" alt=\"Calcular semanas\" data-id=\"45949\" width=\"314\" data-init-width=\"322\" height=\"158\" data-init-height=\"162\" title=\"Datos de Fechas a utilizar\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Datos-de-Fechas-a-utilizar.png\" data-link-wrap=\"true\" data-width=\"314\" data-height=\"158\" style=\"aspect-ratio: auto 322 \/ 162;\"><\/span><\/p>\n<p>Debes de escribir las fechas de inicio y las fecha de hoy.<\/p>\n<p>Ya lo tienes listo?<\/p>\n<p>Comencemos entonces:<\/p>\n<h3 style=\"text-align: center;\">Formula para calcular el numero de semanas entre dos fechas de a\u00f1os diferentes<\/h3>\n<p>En primer lugar, nos ubicamos en la celda F5, dentro de este escribimos la siguiente formula:<\/p>\n<blockquote><p><em><strong>=NUM.DE.SEMANA(E5;2)+(NUM.DE.SEMANA(\u00ab31-12-2019\u00bb))-NUM.DE.SEMANA(D5;2)<\/strong><\/em><\/p><\/blockquote>\n<p><em><strong><\/strong><\/em>Donde NUM.DE.SEMANA(E5;2) calcula el numero de semana del 01-01-2020 al 21-04-2020.<\/p>\n<p>+ (NUM.DE.SEMANA(\u00ab31-12-2019\u00bb) Calcula el total de semana que trae el a\u00f1o 2019.<\/p>\n<p>-(NUM.DE.SEMANA(D5;2) calcula el numero de semana del 01-01-2019 al 12-07-2019.<\/p>\n<p>Entonces, aplicando esta formula el resultado es de 42 semanas entre el 12-07-2019 al 21-04-2020.<\/p>\n<p>En seguida, seleccionamos de la Celda F5 hasta la F9 y rellenamos la formula hacia abajo.<\/p>\n<p>Los resultados te deben de quedar asi:<\/p>\n<p><span><img decoding=\"async\" alt=\"Calcular semanas\" data-id=\"45956\" width=\"338\" data-init-width=\"346\" height=\"140\" data-init-height=\"143\" title=\"Resultados de semanas entre dos fechas de a\u00f1os diferentes\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Resultados-de-semanas-entre-dos-fechas-de-a\u00f1os-diferentes.png\" data-link-wrap=\"true\" data-width=\"338\" data-height=\"140\" style=\"aspect-ratio: auto 346 \/ 143;\"><\/span><\/p>\n<p>Con estos sencillos pasos, podr\u00e1s calcular el numero de semanas entre dos fechas de a\u00f1os diferentes.<\/p>\n<p>Que tal te pareci\u00f3 el articulo de hoy \u00abCalcular semanas entre dos fechas de a\u00f1os diferentes\u00bb? Te gusto?<\/p>\n<p>Si te gusto, te invito a compartirlo con tus amigos por correo electr\u00f3nico, WhatsApp o bien por&nbsp;<a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" rel=\"noopener\" target=\"_blank\" style=\"outline: none;\">Facebook<\/a>, a continuaci\u00f3n te dejo un bot\u00f3n para que puedas compartirlo:<\/p>\n<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">&nbsp;<\/span><a href=\"#comentario\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Calcular semanas entre dos fechas de a\u00f1os diferentes Estas listo para Calcular semanas entre dos fechas de a\u00f1os diferentes? Antes de compartirte el truco de como Extraer el Numero de semanas entre dos fechas de a\u00f1os diferentes. Quiero compartirte por que decid\u00ed escribir este articulo. Actualmente tenemos un articulo, tambi\u00e9n explicado en video, llamado Como [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":45945,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\"><h1 class=\"\" style=\"text-align: center;\" data-css=\"tve-u-1943899d0e1\">Calcular semanas entre dos fechas de a\u00f1os diferentes<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-194389a4a3f\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-194389a4a3a\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Estas listo para Calcular semanas entre dos fechas de a\u00f1os diferentes?<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-171a00c6fc1\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-45945\" alt=\"Calcular semanas\" data-id=\"45945\" width=\"492\" data-init-width=\"500\" height=\"212\" data-init-height=\"215\" title=\"Calcular el numero de semanas a\u00f1os diferentes\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Calcular-el-numero-de-semanas-a\u00f1os-diferentes.png\" data-link-wrap=\"true\" data-width=\"492\" data-height=\"212\" style=\"aspect-ratio: auto 500 \/ 215;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-194389c96e6\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-194389c96e1\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Antes de compartirte el truco de como Extraer el Numero de semanas entre dos fechas de a\u00f1os diferentes.<\/p><p style=\"\">Quiero compartirte por que decid\u00ed escribir este articulo.<\/p><p style=\"\">Actualmente tenemos un articulo, tambi\u00e9n explicado en video, llamado <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/numero-de-semana\" target=\"_blank\" class=\"\" style=\"outline: none;\"><em><strong>Como extraer el numero de semana entre dos fechas<\/strong><\/em><\/a>.<\/p><p style=\"\">Usuarios del blog y nuestros seguidores de YouTube, nos hicieron la pregunta en reiteradas ocasiones:<\/p><blockquote class=\"\"><strong>\"Como puedo calcular el numero de semana entre dos fechas de a\u00f1os diferentes\".<\/strong><\/blockquote><p>Y hoy decidimos escribir la respuesta detalladamente paso a paso.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 class=\"\" style=\"text-align: center;\">Pasos para Calcular semanas entre dos fechas de a\u00f1os diferentes<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19438b79501\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19438b794fc\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Para hacer c\u00e1lculos en Excel lo primero que debes de tomar en cuenta es la funci\u00f3n a utilizar en las formulas.<\/p><p style=\"\">En este caso, vamos a calcular semanas entre dos fechas, por lo tanto, vamos a utilizar la funci\u00f3n NUM.DE.SEMANA.<\/p><p style=\"\">Ahora que ya sabes que funci\u00f3n vas a utilizar en tus formulas, el segundo paso es conocer la sintaxis de la funci\u00f3n.<\/p><p style=\"\">Entonces veamos:&nbsp;<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 style=\"text-align: center;\" class=\"\">Sintaxis de la Funci\u00f3n NUM.DE.SEMANA<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19438cf3a38\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19438cf3a33\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">A continuaci\u00f3n te dejo la sintaxis de la funci\u00f3n NUM.DE.SEMANA:<\/p><blockquote class=\"\" style=\"\"><em><strong>=NUM.DE.SEMANA(n\u00famero_serie;[tipo_devuelto])<\/strong><\/em><\/blockquote><p style=\"\">Donde cada componente de la sintaxis tiene un significado:<\/p><ul class=\"\"><li class=\"\" style=\"\">N\u00famero_serie: Es el c\u00f3digo de fecha-hora utilizado por microsoft Excel para los c\u00e1lculos de fecha y hora.<\/li><li class=\"\" style=\"\">Tipo_devuelto: Es un n\u00famero (1 o 2) que determina el tipo de valor devuelto.<\/li><\/ul><p>Listo, ahora si estas preparado para comenzar a crear la formula para calcular semanas entre dos fechas.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19438a36b01\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19438a36af8\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Para comenzar te invito a que descargues el archivo de practica:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19438a40a8b\" style=\"\" id=\"descarga\">\n\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-19438a40a8c\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19438a40a89\"><div class=\"thrv_wrapper thrv-columns\" data-css=\"tve-u-19438a40a8a\" style=\"--tcb-col-el-width: 645.938;\"><div class=\"tcb-flex-row v-2 tcb-resized tcb--cols--2\"><div class=\"tcb-flex-col\" data-css=\"tve-u-19438a40a85\" style=\"\"><div class=\"tcb-col\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2016\/08\/Ejemplo-Numero-de-Semana-en-Blanco-1.xlsx\" target=\"_blank\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root\" data-css=\"tve-u-19438a40a84\" style=\"\" data-link-wrap=\"true\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 384 512\" data-id=\"icon-file-excel-solid\" data-name=\"\" style=\"\"><path d=\"M224 136V0H24C10.7 0 0 10.7 0 24v464c0 13.3 10.7 24 24 24h336c13.3 0 24-10.7 24-24V160H248c-13.2 0-24-10.8-24-24zm60.1 106.5L224 336l60.1 93.5c5.1 8-.6 18.5-10.1 18.5h-34.9c-4.4 0-8.5-2.4-10.6-6.3C208.9 405.5 192 373 192 373c-6.4 14.8-10 20-36.6 68.8-2.1 3.9-6.1 6.3-10.5 6.3H110c-9.5 0-15.2-10.5-10.1-18.5l60.3-93.5-60.3-93.5c-5.2-8 .6-18.5 10.1-18.5h34.8c4.4 0 8.5 2.4 10.6 6.3 26.1 48.8 20 33.6 36.6 68.5 0 0 6.1-11.7 36.6-68.5 2.1-3.9 6.2-6.3 10.6-6.3H274c9.5-.1 15.2 10.4 10.1 18.4zM384 121.9v6.1H256V0h6.1c6.4 0 12.5 2.5 17 7l97.9 98c4.5 4.5 7 10.6 7 16.9z\"><\/path><\/svg><\/div><\/a><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-19438a40a86\" style=\"\"><div class=\"tcb-col\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"text-align: center;\" data-css=\"tve-u-19438a40a88\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2016\/08\/Ejemplo-Numero-de-Semana-en-Blanco-1.xlsx\" target=\"_blank\" class=\"\" style=\"outline: none;\"><em><strong>Haz clic para descargar el archivo excel<\/strong><\/em><\/a><\/p><\/div><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Pulsa clic en el enlace o bien en la imagen de excel para descargar el archivo de practica.<\/p><\/div><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root tve_evt_manager_listen tve_et_tve-viewport tve_ea_thrive_animation tve_anim_slide_right\" data-css=\"tve-u-19438a40a8d\" style=\"\" data-tcb-events=\"__TCB_EVENT_[{&quot;t&quot;:&quot;tve-viewport&quot;,&quot;config&quot;:{&quot;anim&quot;:&quot;slide_right&quot;,&quot;loop&quot;:1},&quot;a&quot;:&quot;thrive_animation&quot;}]_TNEVE_BCT__\"><svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-hand-point-up-solid\" data-name=\"\" style=\"\"><path d=\"M135.652 0c23.625 0 43.826 20.65 43.826 44.8v99.851c17.048-16.34 49.766-18.346 70.944 6.299 22.829-14.288 53.017-2.147 62.315 16.45C361.878 158.426 384 189.346 384 240c0 2.746-.203 13.276-.195 16 .168 61.971-31.065 76.894-38.315 123.731C343.683 391.404 333.599 400 321.786 400H150.261l-.001-.002c-18.366-.011-35.889-10.607-43.845-28.464C93.421 342.648 57.377 276.122 29.092 264 10.897 256.203.008 242.616 0 224c-.014-34.222 35.098-57.752 66.908-44.119 8.359 3.583 16.67 8.312 24.918 14.153V44.8c0-23.45 20.543-44.8 43.826-44.8zM136 416h192c13.255 0 24 10.745 24 24v48c0 13.255-10.745 24-24 24H136c-13.255 0-24-10.745-24-24v-48c0-13.255 10.745-24 24-24zm168 28c-11.046 0-20 8.954-20 20s8.954 20 20 20 20-8.954 20-20-8.954-20-20-20z\"><\/path><\/svg><\/div><\/div><\/div><\/div><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19438a62673\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19438a6266f\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Dentro del archivo, escribe las siguientes fechas, tal a como se muestra en la imagen:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-171a0176b3b\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-45949\" alt=\"Calcular semanas\" data-id=\"45949\" width=\"314\" data-init-width=\"322\" height=\"158\" data-init-height=\"162\" title=\"Datos de Fechas a utilizar\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Datos-de-Fechas-a-utilizar.png\" data-link-wrap=\"true\" data-width=\"314\" data-height=\"158\" style=\"aspect-ratio: auto 322 \/ 162;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19438a62673\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19438a6266f\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Debes de escribir las fechas de inicio y las fecha de hoy.<\/p><p>Ya lo tienes listo?<\/p><p>Comencemos entonces:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 class=\"\" style=\"text-align: center;\">Formula para calcular el numero de semanas entre dos fechas de a\u00f1os diferentes<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19438a62673\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19438a6266f\"><div class=\"thrv_wrapper thrv_text_element\"><p>En primer lugar, nos ubicamos en la celda F5, dentro de este escribimos la siguiente formula:<\/p><blockquote class=\"\"><em><strong>=NUM.DE.SEMANA(E5;2)+(NUM.DE.SEMANA(\"31-12-2019\"))-NUM.DE.SEMANA(D5;2)<\/strong><\/em><\/blockquote><p><em><strong><\/strong><\/em>Donde NUM.DE.SEMANA(E5;2) calcula el numero de semana del 01-01-2020 al 21-04-2020.<\/p><p>+ (NUM.DE.SEMANA(\"31-12-2019\") Calcula el total de semana que trae el a\u00f1o 2019.<\/p><p>-(NUM.DE.SEMANA(D5;2) calcula el numero de semana del 01-01-2019 al 12-07-2019.<\/p><p>Entonces, aplicando esta formula el resultado es de 42 semanas entre el 12-07-2019 al 21-04-2020.<\/p><p>En seguida, seleccionamos de la Celda F5 hasta la F9 y rellenamos la formula hacia abajo.<\/p><p>Los resultados te deben de quedar asi:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-171a029bd9c\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-45956\" alt=\"Calcular semanas\" data-id=\"45956\" width=\"338\" data-init-width=\"346\" height=\"140\" data-init-height=\"143\" title=\"Resultados de semanas entre dos fechas de a\u00f1os diferentes\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Resultados-de-semanas-entre-dos-fechas-de-a\u00f1os-diferentes.png\" data-link-wrap=\"true\" data-width=\"338\" data-height=\"140\" style=\"aspect-ratio: auto 346 \/ 143;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19438ab7ddf\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19438ab7dda\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Con estos sencillos pasos, podr\u00e1s calcular el numero de semanas entre dos fechas de a\u00f1os diferentes.<\/p><p>Que tal te pareci\u00f3 el articulo de hoy \"Calcular semanas entre dos fechas de a\u00f1os diferentes\"? Te gusto?<\/p><p>Si te gusto, te invito a compartirlo con tus amigos por correo electr\u00f3nico, WhatsApp o bien por&nbsp;<a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" rel=\"noopener\" target=\"_blank\" class=\"\" style=\"outline: none;\">Facebook<\/a>, a continuaci\u00f3n te dejo un bot\u00f3n para que puedas compartirlo:<\/p><\/div><\/div>\n<\/div><div class=\"tcb-clear\" data-css=\"tve-u-19438b07a03\"><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" data-device-config=\"{&quot;desktop&quot;:{&quot;isFullWidth&quot;:&quot;0&quot;},&quot;tablet&quot;:{},&quot;mobile&quot;:{&quot;button_type&quot;:&quot;tve_social_ib&quot;,&quot;showCount&quot;:&quot;0&quot;}}\" data-css=\"tve-u-19438b07a01\" style=\"\">\n<div class=\"tve_social_items tve_social_custom tve-prevent-content-edit tve_style_6 tve_social_itb\">\n\t\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_fb_share tve_share_item\" data-s=\"fb_share\" data-href=\"{tcb_post_url}\" data-label=\"Compartir\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 264 512\" data-id=\"icon-fb\" data-name=\"\">\n            <path d=\"M76.7 512V283H0v-91h76.7v-71.7C76.7 42.4 124.3 0 193.8 0c33.3 0 61.9 2.5 70.2 3.6V85h-48.2c-37.8 0-45.1 18-45.1 44.3V192H256l-11.7 91h-73.6v229\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Compartir<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_t_share tve_share_item\" data-s=\"t_share\" data-href=\"{tcb_post_url}\" data-label=\"Tweet\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-t\" data-name=\"\">\n            <path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text tve-froala\">Tweet<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_pin_share tve_share_item\" data-s=\"pin_share\" data-href=\"{tcb_post_url}\" data-label=\"Pin\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-pin\" data-name=\"\">\n            <path d=\"M204 6.5C101.4 6.5 0 74.9 0 185.6 0 256 39.6 296 63.6 296c9.9 0 15.6-27.6 15.6-35.4 0-9.3-23.7-29.1-23.7-67.8 0-80.4 61.2-137.4 140.4-137.4 68.1 0 118.5 38.7 118.5 109.8 0 53.1-21.3 152.7-90.3 152.7-24.9 0-46.2-18-46.2-43.8 0-37.8 26.4-74.4 26.4-113.4 0-66.2-93.9-54.2-93.9 25.8 0 16.8 2.1 35.4 9.6 50.7-13.8 59.4-42 147.9-42 209.1 0 18.9 2.7 37.5 4.5 56.4 3.4 3.8 1.7 3.4 6.9 1.5 50.4-69 48.6-82.5 71.4-172.8 12.3 23.4 44.1 36 69.3 36 106.2 0 153.9-103.5 153.9-196.8C384 71.3 298.2 6.5 204 6.5z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Pin<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\n<\/div>\n<\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19438b1af83\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19438b1af81\"><div class=\"thrv_wrapper thrv_text_element tcb-highlight-added\">\t<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-19438b1af84\">&nbsp;<\/span><a href=\"#comentario\" class=\"tve-jump-scroll\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-19438b1af85\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-css=\"tve-u-19438b1af86\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\" data-css=\"tve-u-19438b1af87\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-19438b1af88\"><\/span><\/p><p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p><p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){[data-css=\"tve-u-171a00c6fc1\"] { width: 500px; float: none; border: 4px dashed rgb(236, 147, 11); border-radius: 10px; overflow: hidden; margin: 20px auto 10px !important; }[data-css=\"tve-u-171a0176b3b\"] { width: 322px; float: none; border-radius: 10px; overflow: hidden; border: 4px dashed rgb(208, 14, 227); margin: 0px auto 10px !important; }[data-css=\"tve-u-171a029bd9c\"] { width: 346px; float: none; border: 4px dashed rgb(232, 44, 95); border-radius: 10px; overflow: hidden; margin: 0px auto 10px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper { width: calc(100% + 0px); }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n+2) { margin-top: 50px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+2)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n)) { margin-right: 30px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n) { margin-right: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper { width: calc(33.3333% - 13.3333px); }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n+4) { margin-top: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+4)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(3n)) { margin-right: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(3n) { margin-right: 0px !important; }:not(#tve) [data-css=\"tve-u-1943899d0e1\"] { text-transform: none !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-194389a4a3a\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389a4a3a\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-194389a4a3a\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-194389a4a3f\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-194389c96e1\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-194389c96e1\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-194389c96e1\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-194389c96e6\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19438a36af8\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a36af8\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19438a36af8\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19438a36b01\"] { margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-19438a40a84\"] { font-size: 84px; margin-left: auto; margin-right: auto; --tcb-local-color-icon: rgb(4,228,38); --tcb-local-color-var: rgb(4,228,38); --tve-icon-size: 84px; --tcb-icon-rotation-angle: -22deg; width: 84px; height: 84px; }:not(#tve) [data-css=\"tve-u-19438a40a84\"] > :first-child { color: rgb(4, 228, 38); --tve-applied-color: rgb(4,228,38); }[data-css=\"tve-u-19438a40a85\"] { max-width: 18.1%; }[data-css=\"tve-u-19438a40a86\"] { max-width: 81.9%; }:not(#tve) [data-css=\"tve-u-19438a40a88\"] { font-size: 21px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19438a40a89\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a40a89\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a40a89\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a40a89\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a40a89\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a40a89\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a40a89\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a40a89\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a40a89\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a40a89\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a40a89\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a40a89\"] h6 { color: var(--tve-color,rgb(0,3,6)); --tve-applied-color: var$(--tve-color,rgb(0,3,6)); --tcb-applied-color: rgb(0,3,6); }[data-css=\"tve-u-19438a40a89\"] { --tve-color: rgb(0,3,6); --tve-applied---tve-color: rgb(0,3,6); text-align: justify; }[data-css=\"tve-u-19438a40a89\"] p { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-19438a40a8a\"] { margin-bottom: 0px !important; margin-top: 0px !important; }[data-css=\"tve-u-19438a40a8b\"] { margin-top: 0px !important; padding-top: 0px !important; padding-bottom: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-19438a40a8c\"] { --tve-border-width: 6px; --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; border: 6px dashed rgb(234, 194, 13) !important; --tve-applied-border: 6px dashed rgb(234,194,13) !important; }[data-css=\"tve-u-19438a40a8d\"] { font-size: 60px; --tcb-local-color-icon: rgb(227,12,38); --tcb-local-color-var: rgb(227,12,38); --tve-icon-size: 60px; float: none; z-index: 3; position: relative; --tve-alignment: center; margin: -109px auto 0px !important; padding-top: 0px !important; }:not(#tve) [data-css=\"tve-u-19438a40a8d\"] > :first-child { color: rgb(227, 12, 38); --tve-applied-color: rgb(227,12,38); }:not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19438a6266f\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438a6266f\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19438a6266f\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19438a62673\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19438ab7dda\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438ab7dda\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19438ab7dda\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19438ab7ddf\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-19438b07a01\"] { float: right; z-index: 3; position: relative; --tve-alignment: right; margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-19438b07a03\"]::after { clear: both; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19438b1af81\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b1af81\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19438b1af81\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19438b1af83\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-19438b1af84\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-19438b1af85\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-19438b1af86\"] { --tve-highlight-background: url(\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20314%20114%22%20preserveAspectRatio%3D'none'%3E%0A%09%09%09%09%09%3Cpath%20d%3D%22M149.412%202.398C98.053%204.579%2074.996%207.562%2053.903%2014.754%2028.892%2023.283%208.503%2040.617%202.929%2058.09c-4.148%2013.004-.464%2026.402%2010.207%2037.118%205.664%205.687%2015.228%2012.328%2021.753%2015.104%202.939%201.25%208.598%202.708%2010.559%202.72%201.16.008%201.111-.129-.909-2.543-2.554-3.05-4.753-7.567-4.761-9.775-.008-2.502%202.482-6.937%204.862-8.661%205.613-4.066%2020.333-6.115%2050.607-7.046%2012.81-.394%2019.622.068%2047.623%203.231%2057%206.439%2066.925%207.222%2091.845%207.248%2016.516.016%2020.951-.139%2026.167-.919%2020.12-3.007%2032.633-8.401%2041.489-17.883%206.859-7.344%2010.154-16.516%2010.254-28.537.032-3.902-.231-7.704-.651-9.42-5.257-21.464-31.961-33.668-80.137-36.622-11.85-.727-62.651-.546-82.425.293%22%2F%3E%0A%09%09%09%09%3C%2Fsvg%3E\"); --tcb-text-highlight-color: #2ABB61 !important; }[data-css=\"tve-u-19438b1af87\"] { --tcb-text-highlight-color: rgb(30,184,76) !important; }[data-css=\"tve-u-19438b1af88\"] { --tcb-text-highlight-color: transparent !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19438b794fc\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438b794fc\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19438b794fc\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19438b79501\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19438cf3a33\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19438cf3a33\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19438cf3a33\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19438cf3a38\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 10px !important; padding-bottom: 0px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"0","_tve_footer":"0"},"categories":[72],"tags":[7413,7410,7412,7411],"class_list":["post-45941","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas-excel","tag-anos-diferentes","tag-calcular-semanas","tag-dos-fechas","tag-semans-entre-dos-fechas-de-anos-diferentes","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/45941","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=45941"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/45941\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/45945"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=45941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=45941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=45941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}