Question: how to change date format in excel to include day of the week?
Answer: Method #2: The Format Cells Dialog Window This window can be opened by right-clicking the cell, then pressing Format Cells… Click on the Long Date format and the Sample box will show a preview that includes the day of the week. You can also apply a Custom number format to just display the weekday name in the cell.