{"id":28872,"date":"2023-05-12T18:00:33","date_gmt":"2023-05-12T16:00:33","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=28872"},"modified":"2024-02-06T16:21:20","modified_gmt":"2024-02-06T15:21:20","slug":"get-the-day-name-for-a-date-in-microsoft-excel-3-easy-ways","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/get-the-day-name-for-a-date-in-microsoft-excel-3-easy-ways\/","title":{"rendered":"Get the Day Name for a Date in Microsoft Excel &#8211; 3 Easy Ways"},"content":{"rendered":"<p><em><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/FA0E395E-6D26-4D7F-B5CC-927961F5D4BF.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\"  class=\"aligncenter wp-image-28881 size-large\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/FA0E395E-6D26-4D7F-B5CC-927961F5D4BF-1024x576.png\" alt=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/FA0E395E-6D26-4D7F-B5CC-927961F5D4BF-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/FA0E395E-6D26-4D7F-B5CC-927961F5D4BF-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/FA0E395E-6D26-4D7F-B5CC-927961F5D4BF-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/FA0E395E-6D26-4D7F-B5CC-927961F5D4BF.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/em><\/p>\n<p>Picture this: you are a Project Manager. Your current objective is to delegate various tasks to your team members, and spread them evenly throughout the work week. However, all you have are dates, and you have no way of knowing what days of the week these dates fall on.<\/p>\n<p>In this article, we will explore the <strong>3 Easy Ways to Get a Day Name For A Date in <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\" title=\"Microsoft Excel\" data-wpil-keyword-link=\"linked\">Microsoft Excel<\/a><\/strong>.<\/p>\n<\/h4>\n<ul>\n<li><a href=\"#1\"><strong>Method 1: The TEXT Function<\/strong><\/a><\/li>\n<li><a href=\"#2\"><strong>Method 2: The WEEKDAY Function<\/strong><\/a><\/li>\n<li><a href=\"#3\"><strong>Method 3: The Custom Number Format<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s look at these methods thoroughly!<\/p>\n<p><strong>Download the Excel Workbook below to follow along and understand how to Get the Day Name for a Date in Excel &#8211;<\/strong><\/p>\n<h4><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Day-Name-for-a-Date.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">Day-Name-for-a-Date.xlsx<\/span><\/a><\/h4>\n<p><strong><span id=\"1\" style=\"color: #ff0000!important;\">Method 1: The TEXT Function<\/span><\/strong><\/p>\n<p>One of the easiest ways to get the day name from a date in Microsoft Excel is by using the TEXT function. The TEXT function allows you to format a date or time value in a specific way, including returning the day name.<\/p>\n<p>To use the TEXT function to get the day name for a date, simply enter the following <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> in a cell:<\/p>\n<p><strong>=TEXT(A2,&#8221;dddd&#8221;)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/D350717F-2AC0-4329-90D8-48BCAC0F5BFD.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\"  class=\"aligncenter size-large wp-image-28873\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/D350717F-2AC0-4329-90D8-48BCAC0F5BFD-1024x584.jpeg\" alt=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\" width=\"1024\" height=\"584\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/D350717F-2AC0-4329-90D8-48BCAC0F5BFD-1024x584.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/D350717F-2AC0-4329-90D8-48BCAC0F5BFD-300x171.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/D350717F-2AC0-4329-90D8-48BCAC0F5BFD-768x438.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/D350717F-2AC0-4329-90D8-48BCAC0F5BFD.jpeg 1201w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>This is the breakdown of the two arguments needed in the formula: <strong>=TEXT(value, format_text)<\/strong><\/p>\n<p><strong>value<\/strong> &#8211; This is a reference of the cell that contains the date.<\/p>\n<p><strong>format_text<\/strong> &#8211; This format is what we will apply to the value.<\/p>\n<p><strong><span id=\"2\" style=\"color: #ff0000!important;\">Method 2: The WEEKDAY Function<\/span><\/strong><\/p>\n<p>Next, there is the Custom Number format. Using this method, you can change the way numbers and dates are displayed in Excel. It also allows you to display the day name, too!<\/p>\n<p>To use a custom number format to display the day name, <strong>Select the cell<\/strong> containing the date and go to the <strong>Format Cells dialog box (press CTRL+1)<\/strong>. In the Number tab, select the <strong>Custom<\/strong> category, and enter the following custom number format:<\/p>\n<p><strong>ddd<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/36ED3F18-8AEB-46C4-B3B0-0CD0E48CCB24.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\"  class=\"aligncenter size-large wp-image-28874\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/36ED3F18-8AEB-46C4-B3B0-0CD0E48CCB24-1024x576.png\" alt=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/36ED3F18-8AEB-46C4-B3B0-0CD0E48CCB24-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/36ED3F18-8AEB-46C4-B3B0-0CD0E48CCB24-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/36ED3F18-8AEB-46C4-B3B0-0CD0E48CCB24-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/36ED3F18-8AEB-46C4-B3B0-0CD0E48CCB24.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>This custom number format will display the full day name for the date. You can use other format codes to return different formats of the day name, such as &#8220;<strong>ddd<\/strong>&#8221; for a shortened day name.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/5639C00E-8669-44B9-AA74-98C898CD7A33.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\"  class=\"aligncenter size-full wp-image-28875\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/5639C00E-8669-44B9-AA74-98C898CD7A33.jpeg\" alt=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\" width=\"601\" height=\"458\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/5639C00E-8669-44B9-AA74-98C898CD7A33.jpeg 601w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/5639C00E-8669-44B9-AA74-98C898CD7A33-300x229.jpeg 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/a><\/p>\n<p>Note: The cell value will retain its\u2019 date in the background. It will just show the day name instead of the date.<\/p>\n<p><strong><span id=\"3\" style=\"color: #ff0000!important;\">Method 3: The Custom Number Format<\/span><\/strong><\/p>\n<p>The WEEKDAY function returns a number that corresponds to the day of the week for a date. Sunday is represented as 1, and Saturday is 7.<\/p>\n<p>Using the WEEKDAY function, you can obtain a numerical value ranging from 1 to 7 that represents the day of the week. This numerical value can then be used as an index in the Custom Number Format function to retrieve and display the corresponding day name.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/ECB539DC-4573-4B00-87A7-98CB939A8666.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\"  class=\"aligncenter size-large wp-image-28876\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/ECB539DC-4573-4B00-87A7-98CB939A8666-1024x637.jpeg\" alt=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\" width=\"1024\" height=\"637\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/ECB539DC-4573-4B00-87A7-98CB939A8666-1024x637.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/ECB539DC-4573-4B00-87A7-98CB939A8666-300x187.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/ECB539DC-4573-4B00-87A7-98CB939A8666-768x477.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/ECB539DC-4573-4B00-87A7-98CB939A8666.jpeg 1031w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Go to the <strong>Format Cells dialog box<\/strong> or press <strong>CTRL+1<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/94C303CB-C066-45FF-BE62-50B41F54508D.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\"  class=\"aligncenter size-large wp-image-28877\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/94C303CB-C066-45FF-BE62-50B41F54508D-1024x629.jpeg\" alt=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\" width=\"1024\" height=\"629\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/94C303CB-C066-45FF-BE62-50B41F54508D-1024x629.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/94C303CB-C066-45FF-BE62-50B41F54508D-300x184.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/94C303CB-C066-45FF-BE62-50B41F54508D-768x471.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/94C303CB-C066-45FF-BE62-50B41F54508D.jpeg 1085w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Press <strong>ENTER<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/FE3CF45E-2323-4D13-84CE-5BF0EF1609BE.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\"  class=\"aligncenter size-full wp-image-28878\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/FE3CF45E-2323-4D13-84CE-5BF0EF1609BE.jpeg\" alt=\"Get the Day Name for a Date in Microsoft Excel - 3 Easy Ways\" width=\"819\" height=\"399\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/FE3CF45E-2323-4D13-84CE-5BF0EF1609BE.jpeg 819w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/FE3CF45E-2323-4D13-84CE-5BF0EF1609BE-300x146.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/FE3CF45E-2323-4D13-84CE-5BF0EF1609BE-768x374.jpeg 768w\" sizes=\"(max-width: 819px) 100vw, 819px\" \/><\/a><\/p>\n<p>There you have it! As demonstrated, there are several ways to display the day name instead of the date in Excel. Now it\u2019s up to you how you will use these methods to keep you organized in your next project!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Picture this: you are a Project Manager. Your current objective is to delegate various tasks to your team members, and spread them evenly throughout the work week. However, all you have are dates, and you have no way of knowing what days of the week these dates fall on. In this article, we will explore [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":28881,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[515,927,296],"tags":[1213,1210,1214,43,1135,1211,62,1212],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/28872"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=28872"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/28872\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/28881"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=28872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=28872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=28872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}