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

Add to Favorites

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





  1. Right-click the desired cell and click Format Cells
  2. Go to the Number tab and click the Custom category
  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.
    Under where it says Sample you will see the result.
  4. Hit OK and that's it.


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

Download the attached file to see this example in Excel.

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

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...
Get the Day of Week from a Date in Excel
Tutorial: How to get the name of a day from a date in Excel. This returns, for example, "Tuesday" fo...
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 ...