Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Format a Date to Show Only the Day of Week in Excel
How to format a Date so that only the day of the week is visible from that date.
Result:
Steps
- Right-click the desired cell and click Format Cells
- Go to the Number tab and click the Custom category
- 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. - Hit OK and that's it.
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
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 ...
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...
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...
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...
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...
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 ...
Tutorial: How to get the last day of the month, including the date and day of week, for any date in ...