May be useful in certain situations
Excel: How to Display the Day of the Week for a Date – Weekday Function
When you track data in Microsoft Excel, you can take advantage of its built-in date formatting. However, you may want to display the days of the week rather than the exact dates themselves.
If you prefer to see Sunday instead of 1/1/23 or Saturday instead of 12/23/30, we'll show you a few ways to convert the date to the day of the week in Excel.
The easiest way to display weekday names instead of dates in Excel is to change the cell format. If data in a cell is formatted as a date, you can easily change that to a custom format for the day name. This will allow you to keep your days in their current location.
