How to Show Dates as Days of the Week in Microsoft Excel
When you’re tracking data in Microsoft Excel, you can take advantage of the built-in date formatting. However, you may want to display the days of the week instead of the exact dates themselves. If you prefer to see Sunday instead of 1/1/23 or Saturday instead of 23-Dec-30, we’ll show you a few ways to convert the date to the day of the week in Excel. Change the Cell Formatting The easiest way to display weekday names instead of dates in Excel is by changing the cell formatting. When data in a cell is formatted as a date, you can simply change that to a custom format for the day name. This allows you to keep your days in their current location. Select the cell, column, or cell range containing the dates you want to change by dragging your cursor through them. Do one of the following: Right-click and choose Format Cells . Go to the Home tab, open the Number Format drop-down box, and choose More Number Formats . When the Format Cells dialog box appears, make sure you’r