{"id":7232,"date":"2023-07-13T06:41:00","date_gmt":"2023-07-13T04:41:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=7232"},"modified":"2022-11-16T09:58:54","modified_gmt":"2022-11-16T08:58:54","slug":"extraer-el-dia-de-la-semana-con-excel","status":"publish","type":"post","link":"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/","title":{"rendered":"Extraer el d\u00eda de la semana con Excel a partir de una fecha"},"content":{"rendered":"\n<p><strong>\u00bfComo extraer el d\u00eda de la semana de una fecha, en letras con Excel ? Cuando se utilizan fechas en Excel, es m\u00e1s conveniente mostrar el nombre del d\u00eda en lugar de la fecha en el formato de fecha de Excel. \u00bfC\u00f3mo mostrar el nombre del d\u00eda de la semana de una fecha en su totalidad con Excel?<\/strong><\/p>\n\n\n\n<p>De hecho, cuando se utiliza Excel para gestionar los horarios, la legibilidad es importante. Aqu\u00ed hay un art\u00edculo que muestra dos formas de saber el nombre del d\u00eda de la semana en letras a partir de una fecha con una f\u00f3rmula de Excel.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#%c2%bfcomo-extraer-el-dia-de-la-semana-con-excel\" >\u00bfC\u00f3mo extraer el d\u00eda de la semana con Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#1-dia-de-la-semana-completo-a-partir-de-la-fecha-del-dia\" >1. D\u00eda de la semana completo a partir de la fecha del d\u00eda<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#2-extraer-el-nombre-del-dia-completo-desde-otra-celda\" >2. Extraer el nombre del d\u00eda completo desde otra celda<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#3-extraer-el-dia-de-la-semana-en-mayusculas-a-partir-de-una-fecha\" >3. Extraer el d\u00eda de la semana en may\u00fasculas a partir de una fecha<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#4-formula-para-extraer-el-dia-solo-en-tres-letras\" >4. Formula para extraer el d\u00eda s\u00f3lo en tres letras<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#para-terminar-con-la-funcion-de-texto-de-excel\" >Para terminar con la funci\u00f3n de texto de Excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-como-extraer-el-dia-de-la-semana-con-excel\"><span class=\"ez-toc-section\" id=\"%c2%bfcomo-extraer-el-dia-de-la-semana-con-excel\"><\/span>\u00bfC\u00f3mo extraer el d\u00eda de la semana con Excel?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>El formato de fecha del tipo d\u00eda\/mes\/a\u00f1o en num\u00e9rico, como \u00ab30\/11\/2017\u00bb no es necesariamente el m\u00e1s f\u00e1cil de leer. Especialmente con d\u00edas menores o iguales a 12, porque el mes puede confundirse con el d\u00eda. Y el formato anglosaj\u00f3n utiliza mes\/d\u00eda\/a\u00f1o en su lugar, lo que puede dar fechas como 11\/11\/2011. As\u00ed que aqu\u00ed es c\u00f3mo convertir la fecha a d\u00eda de Excel. Estos dos ejemplos concretos muestran el d\u00eda escrito en letras.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-dia-de-la-semana-completo-a-partir-de-la-fecha-del-dia\"><\/span>1. D\u00eda de la semana completo a partir de la fecha del d\u00eda<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Para extraer el d\u00eda en letras en Excel, una soluci\u00f3n es utilizar la <strong>funci\u00f3n de Excel TEXTO()<\/strong> con el par\u00e1metro del d\u00eda de cuatro letras: <strong><em>dddd<\/em><\/strong>. Utilice la funci\u00f3n con la fecha de hoy, por ejemplo, jueves:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">=TEXTO(HOY(),\"dddd\")\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-extraer-el-nombre-del-dia-completo-desde-otra-celda\"><\/span>2. Extraer el nombre del d\u00eda completo desde otra celda<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Utilice la funci\u00f3n con la fecha contenida en otra celda del libro de Excel, como en el ejemplo siguiente:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">=TEXTO(B2,\"dddd\")<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-extraer-el-dia-de-la-semana-en-mayusculas-a-partir-de-una-fecha\"><\/span>3. Extraer el d\u00eda de la semana en may\u00fasculas a partir de una fecha<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Para convertir la fecha de hoy en letras con Excel en may\u00fasculas esta vez. Utilice siempre la f\u00f3rmula TEXTO, pero esta vez con el par\u00e1metro en may\u00fasculas: <strong>DDDD<\/strong>, como en este ejemplo, que mostrar\u00e1 JUEVES.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">=TEXTO(B2; \"DDDD\")<\/pre>\n\n\n\n<p>As\u00ed, esta f\u00f3rmula mostrar\u00e1 el nombre del d\u00eda con todas las letras. Es decir, el d\u00eda completo. En este ejemplo la columna tendr\u00e1 el siguiente formato: Jueves<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"530\" height=\"238\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/11\/excel_afficher_jour_lettres.jpg\" alt=\"Utilisar la funci\u00f3n TEXTO para extraer el d\u00eda de la semana con Excel\" class=\"wp-image-4536\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/11\/excel_afficher_jour_lettres.jpg 530w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/11\/excel_afficher_jour_lettres-300x135.jpg 300w\" sizes=\"auto, (max-width: 530px) 100vw, 530px\" \/><figcaption class=\"wp-element-caption\">Utilisar la funci\u00f3n TEXTO para extraer el d\u00eda de la semana con Excel<\/figcaption><\/figure><\/div>\n\n\n<p>Las capturas de pantalla son de una versi\u00f3n inglesa de Excel. El equivalente de la <a href=\"https:\/\/www.gestiopolis.com\/concepto-de-administracion-de-la-funcion-informatica-ensayo\/\" target=\"_blank\" rel=\"noreferrer noopener\">funci\u00f3n<\/a> espa\u00f1ola TEXTO() es TEXT() en ingl\u00e9s.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-formula-para-extraer-el-dia-solo-en-tres-letras\"><\/span>4. Formula para extraer el d\u00eda s\u00f3lo en tres letras<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En otras palabras, es possible mostrar s\u00f3lo las tres primeras letras del d\u00eda en une formula Excel. Para ello, <strong>utilice la funci\u00f3n TEXTO()<\/strong> con la palabra clave <strong><em>ddd<\/em><\/strong>.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">=TEXTO(B2,\"ddd\")<\/pre>\n\n\n\n<p>En este ejemplo para convertir una fecha de Excel en un d\u00eda, la celda mostrar\u00e1: <strong>Jue <\/strong>(por Jueves)<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"530\" height=\"240\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/11\/excel_afficher_jour_lettres_resultat.jpg\" alt=\"Funci\u00f3n Excel TEXT para extraer el d\u00eda de la semana en tres letras\" class=\"wp-image-4538\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/11\/excel_afficher_jour_lettres_resultat.jpg 530w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/11\/excel_afficher_jour_lettres_resultat-300x136.jpg 300w\" sizes=\"auto, (max-width: 530px) 100vw, 530px\" \/><figcaption class=\"wp-element-caption\">Funci\u00f3n Excel TEXT para extraer el d\u00eda de la semana en tres letras<\/figcaption><\/figure><\/div>\n\n\n<p>Adem\u00e1s, la lista de d\u00edas de la semana con la f\u00f3rmula que utiliza la palabra clave de tres letras mostrar\u00e1 los d\u00edas abreviados:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Lun<\/li>\n\n\n\n<li>Mar<\/li>\n\n\n\n<li>Mi\u00e9<\/li>\n\n\n\n<li>Jue<\/li>\n\n\n\n<li>Vie<\/li>\n\n\n\n<li>S\u00e1b<\/li>\n\n\n\n<li>Dom<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"para-terminar-con-la-funcion-de-texto-de-excel\"><\/span>Para terminar con la funci\u00f3n de texto de Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Para concluir, este art\u00edculo presenta c\u00f3mo extraer los d\u00edas de la semana de forma m\u00e1s expl\u00edcita. Tenga en cuenta que esta f\u00f3rmula tambi\u00e9n le permite gestionar el formato de las diferentes informaciones. Entre otros: horas, semanas, meses y a\u00f1os, pero tambi\u00e9n porcentajes, monedas con el s\u00edmbolo del euro (\u20ac) o del d\u00f3lar ($), por ejemplo.<\/p>\n\n\n\n<p>Para ir m\u00e1s all\u00e1, aqu\u00ed hay un art\u00edculo sobre <a href=\"https:\/\/expert-only.com\/es\/excel-consejos\/como-desactivar-el-bloqueo-de-desplazamiento-en-excel\/\">c\u00f3mo desactivar el bloqueo de desplazamiento en Excel<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriales-de-sql-y-ti wp-block-embed-tutoriales-de-sql-y-ti\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"CZscdCxOm5\"><a href=\"https:\/\/expert-only.com\/es\/excel\/desactivar-el-bloqueo-de-desplazamiento\/\">\u00bfC\u00f3mo desactivar el bloqueo de desplazamiento en Excel?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00bfC\u00f3mo desactivar el bloqueo de desplazamiento en Excel?\u00bb \u2014 Tutoriales de SQL y TI\" src=\"https:\/\/expert-only.com\/es\/excel\/desactivar-el-bloqueo-de-desplazamiento\/embed\/#?secret=wRlsqKq6KJ#?secret=CZscdCxOm5\" data-secret=\"CZscdCxOm5\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>\u00bfComo extraer el d\u00eda de la semana de una fecha, en letras con Excel ? Cuando se utilizan fechas en Excel, es m\u00e1s conveniente mostrar el nombre del d\u00eda en lugar de la fecha en el formato de fecha <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/\" title=\"Extraer el d\u00eda de la semana con Excel a partir de una fecha\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5521,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[458],"tags":[],"class_list":{"0":"post-7232","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Extraer el d\u00eda de la semana con Excel a partir de una fecha - Office<\/title>\n<meta name=\"description\" content=\"\u00bfC\u00f3mo extraer el d\u00eda de la semana de una fecha con Excel ? La funci\u00f3n TEXTO de Excel permite mostrar el d\u00eda de la semana de una fecha.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Extraer el d\u00eda de la semana con Excel a partir de una fecha\" \/>\n<meta property=\"og:description\" content=\"\u00bfC\u00f3mo extraer el d\u00eda de la semana de una fecha con Excel ? La funci\u00f3n TEXTO de Excel permite mostrar el d\u00eda de la semana de una fecha.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriales de SQL y TI\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T04:41:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\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:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Extraer el d\u00eda de la semana con Excel a partir de una fecha\",\"datePublished\":\"2023-07-13T04:41:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/\"},\"wordCount\":643,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg\",\"articleSection\":[\"Excel consejos\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/\",\"url\":\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/\",\"name\":\"Extraer el d\u00eda de la semana con Excel a partir de una fecha - Office\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg\",\"datePublished\":\"2023-07-13T04:41:00+00:00\",\"description\":\"\u00bfC\u00f3mo extraer el d\u00eda de la semana de una fecha con Excel ? La funci\u00f3n TEXTO de Excel permite mostrar el d\u00eda de la semana de una fecha.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"es\",\"item\":\"https:\/\/expert-only.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extraer el d\u00eda de la semana con Excel a partir de una fecha\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/es\/#website\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"name\":\"Tutoriales de SQL y TI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/es\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Extraer el d\u00eda de la semana con Excel a partir de una fecha - Office","description":"\u00bfC\u00f3mo extraer el d\u00eda de la semana de una fecha con Excel ? La funci\u00f3n TEXTO de Excel permite mostrar el d\u00eda de la 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:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Extraer el d\u00eda de la semana con Excel a partir de una fecha","og_description":"\u00bfC\u00f3mo extraer el d\u00eda de la semana de una fecha con Excel ? La funci\u00f3n TEXTO de Excel permite mostrar el d\u00eda de la semana de una fecha.","og_url":"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/","og_site_name":"Tutoriales de SQL y TI","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-07-13T04:41:00+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Escrito por":"Expert-Only","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Extraer el d\u00eda de la semana con Excel a partir de una fecha","datePublished":"2023-07-13T04:41:00+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/"},"wordCount":643,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg","articleSection":["Excel consejos"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/","url":"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/","name":"Extraer el d\u00eda de la semana con Excel a partir de una fecha - Office","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg","datePublished":"2023-07-13T04:41:00+00:00","description":"\u00bfC\u00f3mo extraer el d\u00eda de la semana de una fecha con Excel ? La funci\u00f3n TEXTO de Excel permite mostrar el d\u00eda de la semana de una fecha.","breadcrumb":{"@id":"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/es\/excel\/extraer-el-dia-de-la-semana-con-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"es","item":"https:\/\/expert-only.com\/es\/"},{"@type":"ListItem","position":2,"name":"Extraer el d\u00eda de la semana con Excel a partir de una fecha"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/es\/#website","url":"https:\/\/expert-only.com\/es\/","name":"Tutoriales de SQL y TI","description":"","publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/es\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/es\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/7232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/comments?post=7232"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/7232\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media\/5521"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media?parent=7232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/categories?post=7232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/tags?post=7232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}