{"id":113,"date":"2023-11-16T08:18:55","date_gmt":"2023-11-16T08:18:55","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/"},"modified":"2023-12-25T10:24:28","modified_gmt":"2023-12-25T10:24:28","slug":"concatenar-dos-fechas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/","title":{"rendered":"\u00bfc\u00f3mo concatenar r\u00e1pidamente dos fechas?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1616597789\"><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>Como sabes, en Excel, una fecha se guarda como un n\u00famero de serie y cuando quieres concatenar dos fechas, necesitas usar una f\u00f3rmula espec\u00edfica.<\/p>\n<p> En este tutorial, veremos todos los m\u00e9todos que puede utilizar para combinar dos valores en una sola celda.<\/p>\n<h2 class=\"wp-block-heading\"> Combina dos fechas usando la funci\u00f3n de texto.<\/h2>\n<p> En el siguiente ejemplo, tenemos dos fechas en la celda A1 y la celda B1. Y ahora necesitamos combinar estos dos en la celda C1. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66017\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-deux-dates-en-utilisant-la-fonction-de-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"combinar-dos-fechas-usando-la-funci\u00f3n-de-texto\" width=\"701\" height=\"271\"><\/figure>\n<\/div>\n<p> Para escribir una f\u00f3rmula para concatenar dos fechas, siga estos pasos:<\/p>\n<ol type=\"1\">\n<li> Primero, use la funci\u00f3n de texto, y en el texto, la funci\u00f3n se refiere a la celda A1 y usa el formato \u00abdd-mmm-aaaa\u00bb para obtener la primera fecha como texto.<\/li>\n<li> Despu\u00e9s de eso, use un signo y para agregar texto entre dos fechas. Necesita un signo comercial, luego algo de texto y, despu\u00e9s del texto, otro signo comercial.<\/li>\n<li> Luego env\u00eda un mensaje de texto a la funci\u00f3n nuevamente y, en la funci\u00f3n de texto, consulte la celda B1 y use el formato \u00abdd-mmm-aaaa\u00bb para obtener la segunda fecha como texto.<\/li>\n<li> Al final, presione Enter para obtener el resultado en la celda C1.<\/li>\n<\/ol>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A2,\"dd-mmm-yyyy\")&amp;\" to \"&amp;TEXT(B2,\"dd-mmm-yyyy\")<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Cambiar formato al combinar fechas<\/h2>\n<p> Cuando combinas fechas con la funci\u00f3n de texto, tienes la opci\u00f3n de usar un formato diferente. En el siguiente ejemplo, puede ver que utilizamos un formato de fecha larga. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66019\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formats-de-date-de-changement-dans-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"cambiar-formatos-de-fecha-en-f\u00f3rmula\" width=\"771\" height=\"242\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A2,\"mmmm dd, yyyy\")&amp;\" to \"&amp;TEXT(B2,\"mmmm dd, yyyy\")<\/code><\/pre>\n<p> De manera similar, puede usar un formato de fecha diferente y luego combinarlo usando el signo comercial. <\/p>\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\/08\/concatener-deux-dates-2.xlsx\" rel=\"nofollow\">Descargar<\/a><\/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\/comparar-dos-fechas\/\">Comparar dos fechas en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/convertir-fecha-a-numero\/\">Convertir fecha a n\u00famero en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/texto-hasta-la-fecha\/\">Convertir texto a fecha en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/rango-de-fechas\/\">Crear un rango de fechas en Excel<\/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\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/resaltando-entre-dos-fechas\/\">Resaltar fechas entre dos fechas en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/generador-de-fechas-aleatorias\/\">Generador de fechas aleatorias (f\u00f3rmula de Excel) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/combinar-fecha-y-hora\/\">Combinar fecha y hora en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fecha-si\/\">Funci\u00f3n FECHASI en Excel<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Como sabes, en Excel, una fecha se guarda como un n\u00famero de serie y cuando quieres concatenar dos fechas, necesitas usar una f\u00f3rmula espec\u00edfica. En este tutorial, veremos todos los m\u00e9todos que puede utilizar para combinar dos valores en una sola celda. Combina dos fechas usando la funci\u00f3n de texto. En el siguiente ejemplo, tenemos [&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-113","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 concatenar r\u00e1pidamente dos fechas?<\/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\/concatenar-dos-fechas\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo concatenar r\u00e1pidamente dos fechas?\" \/>\n<meta property=\"og:description\" content=\"Como sabes, en Excel, una fecha se guarda como un n\u00famero de serie y cuando quieres concatenar dos fechas, necesitas usar una f\u00f3rmula espec\u00edfica. En este tutorial, veremos todos los m\u00e9todos que puede utilizar para combinar dos valores en una sola celda. Combina dos fechas usando la funci\u00f3n de texto. En el siguiente ejemplo, tenemos [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-deux-dates-en-utilisant-la-fonction-de-texte.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\/concatenar-dos-fechas\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/\",\"name\":\"\u00bfc\u00f3mo concatenar r\u00e1pidamente dos fechas?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-deux-dates-en-utilisant-la-fonction-de-texte.png\",\"datePublished\":\"2023-11-16T08:18:55+00:00\",\"dateModified\":\"2023-12-25T10:24:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-deux-dates-en-utilisant-la-fonction-de-texte.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-deux-dates-en-utilisant-la-fonction-de-texte.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo concatenar r\u00e1pidamente dos fechas?\"}]},{\"@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 concatenar r\u00e1pidamente dos fechas?","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\/concatenar-dos-fechas\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo concatenar r\u00e1pidamente dos fechas?","og_description":"Como sabes, en Excel, una fecha se guarda como un n\u00famero de serie y cuando quieres concatenar dos fechas, necesitas usar una f\u00f3rmula espec\u00edfica. En este tutorial, veremos todos los m\u00e9todos que puede utilizar para combinar dos valores en una sola celda. Combina dos fechas usando la funci\u00f3n de texto. En el siguiente ejemplo, tenemos [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:28+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-deux-dates-en-utilisant-la-fonction-de-texte.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\/concatenar-dos-fechas\/","url":"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/","name":"\u00bfc\u00f3mo concatenar r\u00e1pidamente dos fechas?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-deux-dates-en-utilisant-la-fonction-de-texte.png","datePublished":"2023-11-16T08:18:55+00:00","dateModified":"2023-12-25T10:24:28+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-deux-dates-en-utilisant-la-fonction-de-texte.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-deux-dates-en-utilisant-la-fonction-de-texte.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/concatenar-dos-fechas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo concatenar r\u00e1pidamente dos fechas?"}]},{"@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\/113","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=113"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/113\/revisions"}],"predecessor-version":[{"id":929,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/113\/revisions\/929"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}