{"id":5464,"date":"2023-07-13T06:41:00","date_gmt":"2023-07-13T04:41:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=5464"},"modified":"2023-03-02T18:17:52","modified_gmt":"2023-03-02T17:17:52","slug":"excel-day-of-the-week","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/","title":{"rendered":"How to display Excel day of the week in all letters ?"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\" id=\"h-how-to-display-the-excel-day-of-the-week-from-a-date-with-a-simple-formula\"><strong><em>How to display the Excel day of the week from a date with a simple formula?<\/em><\/strong><\/h4>\n\n\n\n<p>With the Excel software, it is more convenient to display the Excel day of the week in all letters rather than the date in a numeric Date format. Indeed, when using dates with Microsoft Office and especially Excel to manage statistics and schedules tables, readability is important. So, how to display Excel weekday in letters from a date with a simple formula? <\/p>\n\n\n\n<p>The date format of the day\/month\/year type in numeric, like for example &#8220;30\/11\/2017&#8221; is not the easiest to read to analyse data. Especially with days less than or equal to 12, because the month can be confused with the day. And the Anglo-Saxon format uses month\/day\/year instead, which can give dates like 11\/11\/2011. So here is how to convert the date to day name in Excel.<\/p>\n\n\n\n<p>These two following concrete examples allow you to display the weekday written in all letters for the first case, or only the first three letters for the second option.<\/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\/en\/excel\/excel-day-of-the-week\/#1-display-the-excel-weekday-name-in-all-letters\" >1. Display the Excel weekday name in all letters<\/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\/en\/excel\/excel-day-of-the-week\/#2-display-the-weekday-from-another-cell-in-full-letter\" >2. Display the weekday from another cell in full letter<\/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\/en\/excel\/excel-day-of-the-week\/#3-display-the-excel-day-of-the-week-abbreviated-in-three-letters\" >3. Display the Excel day of the week abbreviated in three letters<\/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\/en\/excel\/excel-day-of-the-week\/#4-excel-formula-to-convert-the-day-name-to-uppercase\" >4. Excel formula to convert the day name to uppercase<\/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\/en\/excel\/excel-day-of-the-week\/#5-conclusion-on-displaying-weekdays-using-excel-formulas\" >5. Conclusion on displaying weekdays using Excel formulas<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-display-the-excel-weekday-name-in-all-letters\"><span class=\"ez-toc-section\" id=\"1-display-the-excel-weekday-name-in-all-letters\"><\/span>1. Display the Excel weekday name in all letters<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To display the Excel day of the week in all letters, one solution is to use the TEXT() Excel function with the day parameter on four letters: &#8220;dddd&#8221;. Simply add a formula in a <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/cell-function-51bd39a5-f338-4dbe-a33f-955d67c2b2cf\" target=\"_blank\" rel=\"noreferrer noopener\">cell<\/a>, use the Text() function. Then add the TODAY() keyword as the first argument and the &#8220;dddd&#8221; as the second argument for the function.<\/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=\"\">=TEXT(TODAY(),\"dddd\")<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-display-the-weekday-from-another-cell-in-full-letter\"><span class=\"ez-toc-section\" id=\"2-display-the-weekday-from-another-cell-in-full-letter\"><\/span>2. Display the weekday from another cell in full letter<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>For example if the date to display in A1 cell, this formula do not use the current date with a time function, instead, is simply take a date, static or not, from another cell in the Excel Sheet.<\/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=\"\">=TEXT(A1,\"dddd\")<\/pre>\n\n\n\n<p>The result is <strong><em>Saturday<\/em><\/strong> for 01\/01\/2022 in A1. So, this formula will display the name of the day in all letters. That is to say the complete day. In this example the column will have the following format: <strong><em>Thursday<\/em><\/strong><\/p>\n\n\n\n<p>The formula arguments are from an English (UK) version of MS Excel, the syntax may vary depending on <a href=\"https:\/\/edu.gcfglobal.org\/en\/excel-tips\/understanding-regional-differences-in-excel\/1\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">local language settings<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-display-the-excel-day-of-the-week-abbreviated-in-three-letters\"><span class=\"ez-toc-section\" id=\"3-display-the-excel-day-of-the-week-abbreviated-in-three-letters\"><\/span>3. Display the Excel day of the week abbreviated in three letters<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In other words, to display only the first three letters of the day, you have to use the TEXT() function with the keyword &#8220;dd&#8221;. Of course, if your source value is in another cell, then use the cell reference, here it is A1 in the second formula.<\/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=\"\">=TEXT(TODAY(),\"ddd\") <\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"360\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/excel-day-of-the-week-with-today-function.jpg\" alt=\"Display the excel day of the week from current date using TODAY and TEXT formula\" class=\"wp-image-18750\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/excel-day-of-the-week-with-today-function.jpg 720w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/excel-day-of-the-week-with-today-function-300x150.jpg 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><figcaption class=\"wp-element-caption\">Display the excel day of the week from current date<\/figcaption><\/figure><\/div>\n\n\n<p>The result is <strong>Sat <\/strong>for Saturday. Use also this variation to get the date from another cell.<\/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=\"\">=TEXT(A1,\"ddd\")<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"360\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/excel-day-of-the-week-from-another-cell.jpg\" alt=\"Display the excel day of the week from another cell using the TEXT formula\" class=\"wp-image-18756\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/excel-day-of-the-week-from-another-cell.jpg 720w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/excel-day-of-the-week-from-another-cell-300x150.jpg 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><figcaption class=\"wp-element-caption\">Display the excel day of the week from another cell using the TEXT formula<\/figcaption><\/figure><\/div>\n\n\n<p>In addition, the list of days of the week with the formula that uses the three letters keyword will display the abbreviated days as below:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Mon<\/li>\n\n\n\n<li>Tue<\/li>\n\n\n\n<li>Wed<\/li>\n\n\n\n<li>Thu<\/li>\n\n\n\n<li>Fri<\/li>\n\n\n\n<li>Sat<\/li>\n\n\n\n<li>Sun<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-excel-formula-to-convert-the-day-name-to-uppercase\"><span class=\"ez-toc-section\" id=\"4-excel-formula-to-convert-the-day-name-to-uppercase\"><\/span>4. Excel formula to convert the day name to uppercase<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Let&#8217;s convert today&#8217;s date into letters with Excel in uppercase this time. Always use the TEXT() formula, but this time with the parameter in uppercase: DDDD, as in this example it will display THURSDAY.<\/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=\"\">=TEXT(TODAY(),\"DDDD\")<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-conclusion-on-displaying-weekdays-using-excel-formulas\"><\/span>5. Conclusion on displaying weekdays using Excel formulas<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In conclusion, displaying the Excel day of the week in all letters or abbreviated form can greatly improve data readability. Simple formulas like TEXT() with the appropriate parameters can convert dates to the day name in Excel. You can use these formulas to display the day from a static or dynamic cell, or convert it to uppercase. Give them a try to save time and hassle when working with dates in your spreadsheets. They can help you better analyze your data and manage your schedules.<\/p>\n\n\n\n<p>Note that this TEXT function also allows you to manage the format for different information. Among others: hours, weeks, months, and years but also percentages. And also, currencies with the symbol euro (\u20ac) or dollar ($) for example. To go further, here is a short MS Office tutorial on <a href=\"https:\/\/expert-only.com\/en\/excel\/shortcut-to-select-an-entire-excel-column\/\">how to select an entire column in Excel using a shortcut<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"SRavMUpFz6\"><a href=\"https:\/\/expert-only.com\/en\/excel\/shortcut-to-select-an-entire-excel-column\/\">Shortcut to select an entire Excel column<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Shortcut to select an entire Excel column&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/excel\/shortcut-to-select-an-entire-excel-column\/embed\/#?secret=9idwp4ST2c#?secret=SRavMUpFz6\" data-secret=\"SRavMUpFz6\" 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>How to display the Excel day of the week from a date with a simple formula? With the Excel software, it is more convenient to display the Excel day of the week in all letters rather than the date <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/\" title=\"How to display Excel day of the week in all letters ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5519,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[457],"tags":[],"class_list":{"0":"post-5464","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>How to display Excel day of the week in all letters ? Excel tutorial<\/title>\n<meta name=\"description\" content=\"To display the Excel day of the week in all letters, from a date, use the TEXT function in a formula to display it in full or abbreviated.\" \/>\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\/en\/excel\/excel-day-of-the-week\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to display Excel day of the week in all letters ?\" \/>\n<meta property=\"og:description\" content=\"To display the Excel day of the week in all letters, from a date, use the TEXT function in a formula to display it in full or abbreviated.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"How to display Excel day of the week in all letters ?\",\"datePublished\":\"2023-07-13T04:41:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/\"},\"wordCount\":689,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg\",\"articleSection\":[\"Excel Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/\",\"url\":\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/\",\"name\":\"How to display Excel day of the week in all letters ? Excel tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg\",\"datePublished\":\"2023-07-13T04:41:00+00:00\",\"description\":\"To display the Excel day of the week in all letters, from a date, use the TEXT function in a formula to display it in full or abbreviated.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#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\/en\/excel\/excel-day-of-the-week\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to display Excel day of the week in all letters ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/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\/en\/#\/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\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/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":"How to display Excel day of the week in all letters ? Excel tutorial","description":"To display the Excel day of the week in all letters, from a date, use the TEXT function in a formula to display it in full or abbreviated.","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\/en\/excel\/excel-day-of-the-week\/","og_locale":"en_US","og_type":"article","og_title":"How to display Excel day of the week in all letters ?","og_description":"To display the Excel day of the week in all letters, from a date, use the TEXT function in a formula to display it in full or abbreviated.","og_url":"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/","og_site_name":"SQL and IT Tutorials","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":{"Written by":"Expert-Only","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"How to display Excel day of the week in all letters ?","datePublished":"2023-07-13T04:41:00+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/"},"wordCount":689,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg","articleSection":["Excel Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/","url":"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/","name":"How to display Excel day of the week in all letters ? Excel tutorial","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/clock-6830535_1920.jpg","datePublished":"2023-07-13T04:41:00+00:00","description":"To display the Excel day of the week in all letters, from a date, use the TEXT function in a formula to display it in full or abbreviated.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/excel\/excel-day-of-the-week\/#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\/en\/excel\/excel-day-of-the-week\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to display Excel day of the week in all letters ?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/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\/en\/#\/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\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/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\/en\/wp-json\/wp\/v2\/posts\/5464","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=5464"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/5464\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/5519"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=5464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=5464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=5464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}