Format a Date to Show Only the Day of Week in Excel

Edit
Add to Favorites
Author:

How to format a Date so that only the day of the week is visible from that date.

a6751d0915e56557087bba7fa4a8239f.jpg

Result:

b5b47f738e92b8b0b216de10e472ab6f.jpg

Steps

  1. Right-click the desired cell and click Format Cells
    d42b7c473fcd0c064686279b97b64dd6.png
  2. Go to the Number tab and click the Custom category
    04acf6279e6a5d082811cdb972ad35a1.png
  3. Under where it says Type: you need to enter dddd for the full version of the day of the week or ddd for the abbreviated version.
    6745e189521d708d08eda9c669a2b00c.jpg
    Under where it says Sample you will see the result.
  4. Hit OK and that's it.
    08a46a47db261b13943c1871efce34e6.png

Notes

View our other tutorial to get the day of the week from a date.

Download the attached file to see this example in Excel.

Question? Ask it in our Excel Forum


Excel Version: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016
Downloadable Files: Excel File
Similar Content on TeachExcel
Filter Data to Show Only the Bottom 10 Items in Excel - AutoFilter
Macro: This Excel macro filters a selection of data in order to display only the bottom 10 items ...
Display the Current Day of the Week in Excel
Tutorial: Use a formula or formatting to display the current day of the week in Excel. Sections: For...
Filter Data in Excel to Show Only the Top X Percent of that Data Set - AutoFilter
Macro: This Excel macro filters a set of data in Excel and displays only the top X percent of tha...
Add an Input Message to a Cell - Message Appears When the Cell is Selected in Excel - Data Validation Macro
Macro: Add data validation input messages to cells in Excel with this free Excel macro. These mes...
Get the Last Day of the Month in Excel
Tutorial: How to get the last day of the month, including the date and day of week, for any date in ...
Get the Day of the Week (1 to 7) for a Date in Excel - WEEKDAY
Tutorial: Use a function in Excel to get the number of the day in a week, from 1 to 7.  This allow...