{"id":135,"date":"2023-11-15T12:06:15","date_gmt":"2023-11-15T12:06:15","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/"},"modified":"2023-12-25T10:27:41","modified_gmt":"2023-12-25T10:27:41","slug":"agregar-la-fecha-de-la-semana","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/","title":{"rendered":"\u00bfc\u00f3mo sumar\/restar una semana de una fecha?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-32463934\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>Para sumar o restar una fecha de Excel, existe un m\u00e9todo aritm\u00e9tico simple que puede utilizar. Pero, aparte de eso, hay algunas otras formas que puedes utilizar. En este tutorial, veremos todos estos m\u00e9todos uno por uno.<\/p>\n<h2 id=\"add-a-week-in-a-date\" class=\"wp-block-heading\"> Agregar una semana a una fecha<\/h2>\n<p> En el siguiente ejemplo, tiene una fecha en la celda A1 y ahora necesita agregar una semana a la fecha. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64159\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"agregar una semana a una fecha\" width=\"414\" height=\"271\"><\/figure>\n<\/div>\n<ol type=\"1\">\n<li> Primero, ingrese \u00ab=\u00bb en la celda B1.<\/li>\n<li> A continuaci\u00f3n, consulte la celda donde tiene la fecha.<\/li>\n<li> Ahora ingrese \u201c+\u201d para agregar.<\/li>\n<li> Al final, ingrese 7 para agregar una semana a la fecha. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64160\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-semaine-et-date-dans-une-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"fin de semana y fecha en una columna\" width=\"507\" height=\"286\"><\/figure>\n<\/div>\n<p> Como puede ver, despu\u00e9s de agregar siete d\u00edas a los datos, obtuvo el 8 <sup>de diciembre<\/sup> , exactamente una semana despu\u00e9s del <sup>1<\/sup> de diciembre. Ahora bien, si quieres sumar m\u00e1s de una semana a una fecha, puedes multiplicar el 7 con este n\u00famero. . <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64161\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-ajouter-des-nombres-dans-la-date-de-la-semaine.png\" sizes=\"auto, \" srcset=\"\" alt=\"agregar n\u00fameros en la fecha de la semana\" width=\"520\" height=\"249\"><\/figure>\n<\/div>\n<p> En el ejemplo anterior, multiplica (7*3) para sumar los 21 d\u00edas, lo que equivale a 3 semanas.<\/p>\n<h2 id=\"subtract-week-from-a-data\" class=\"wp-block-heading\"> Resta una semana de los datos<\/h2>\n<p> Usando exactamente el mismo m\u00e9todo, tambi\u00e9n puedes restar una semana o varias semanas de una fecha. Deber\u00edas usar resta en lugar de suma. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64162\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-soustraire-une-semaine-a-une-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"restar-semana-de-una-fecha\" width=\"517\" height=\"286\"><\/figure>\n<\/div>\n<p> Y si quieres restar m\u00e1s de una semana a una fecha, puedes multiplicar 7 por ese n\u00famero. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64163\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-soustraire-une-semaine-de-la-date-de-la-semaine.png\" sizes=\"auto, \" srcset=\"\" alt=\"restar-una-semana-de-la-fecha-de-la-semana\" width=\"536\" height=\"276\"><\/figure>\n<\/div>\n<h2 id=\"other-methods-sum-function\" class=\"wp-block-heading\"> Otros m\u00e9todos (funci\u00f3n SUMA)<\/h2>\n<p> Existe otro m\u00e9todo que puede utilizar para sumar o restar semanas a una fecha. En lugar de utilizar un operador de suma o resta, puede utilizar la funci\u00f3n de suma.<\/p>\n<p> En el siguiente ejemplo tienes la funci\u00f3n suma donde el primer argumento es la fecha y en el segundo argumento tenemos 7 para agregarle una semana a la fecha. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM(A1,7)<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64164\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-fonction-de-somme-ajouter-supprimer-la-date-de-la-semaine.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n-suma-agregar-eliminar-fecha-semana\" width=\"531\" height=\"293\"><\/figure>\n<\/div>\n<p> Y esto durante varias semanas. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM(A1,7*3)<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64165\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-ajouter-plusieurs-semaines-dans-la-date-de-la-semaine.png\" sizes=\"auto, \" srcset=\"\" alt=\"agregar-varias-semanas-en-fecha-semana\" width=\"549\" height=\"261\"><\/figure>\n<\/div>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/ajouter-une-semaine-a-une-date-2.xlsx\" rel=\"nofollow\">Descargar<\/a><\/p>\n<\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/obtener-el-nombre-del-dia\/\">Obtener el nombre del d\u00eda a partir de una fecha en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/dias-del-mes\/\">Obtener el n\u00famero total de d\u00edas de meses en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/meses-dias-laborables\/\">D\u00edas laborables en un mes.<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fecha-al-texto-2\/\">Convertir fecha a texto<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Para sumar o restar una fecha de Excel, existe un m\u00e9todo aritm\u00e9tico simple que puede utilizar. Pero, aparte de eso, hay algunas otras formas que puedes utilizar. En este tutorial, veremos todos estos m\u00e9todos uno por uno. Agregar una semana a una fecha En el siguiente ejemplo, tiene una fecha en la celda A1 y [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-135","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo sumar\/restar una semana de una fecha?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo sumar\/restar una semana de una fecha?\" \/>\n<meta property=\"og:description\" content=\"Para sumar o restar una fecha de Excel, existe un m\u00e9todo aritm\u00e9tico simple que puede utilizar. Pero, aparte de eso, hay algunas otras formas que puedes utilizar. En este tutorial, veremos todos estos m\u00e9todos uno por uno. Agregar una semana a una fecha En el siguiente ejemplo, tiene una fecha en la celda A1 y [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:27:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/\",\"name\":\"\u00bfc\u00f3mo sumar\/restar una semana de una fecha?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png\",\"datePublished\":\"2023-11-15T12:06:15+00:00\",\"dateModified\":\"2023-12-25T10:27:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo sumar\/restar una semana de una fecha?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo sumar\/restar una semana de una fecha?","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:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo sumar\/restar una semana de una fecha?","og_description":"Para sumar o restar una fecha de Excel, existe un m\u00e9todo aritm\u00e9tico simple que puede utilizar. Pero, aparte de eso, hay algunas otras formas que puedes utilizar. En este tutorial, veremos todos estos m\u00e9todos uno por uno. Agregar una semana a una fecha En el siguiente ejemplo, tiene una fecha en la celda A1 y [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:27:41+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/","url":"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/","name":"\u00bfc\u00f3mo sumar\/restar una semana de una fecha?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png","datePublished":"2023-11-15T12:06:15+00:00","dateModified":"2023-12-25T10:27:41+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo sumar\/restar una semana de una fecha?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=135"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/135\/revisions"}],"predecessor-version":[{"id":1218,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/135\/revisions\/1218"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}