Change multiple dates to day of week in Excel?

To totally unlock this section you need to Log-in

Login

Sometimes you may need to convert or change the date format in Excel, such as to convert the date into only display the day of week, the month or the year in cells. This article will show you the tricky things to quickly format or change date formatting in Excel.

Change date to only display day of week in cells with Format Cells function

You can change multiple dates to day of week with the following steps:

Select the range that you want to change the dates.

Click Home > Format >Format Cells, and a Format Cells dialog box will appear, then click Number, and choose Custom from the Category, then enter “dddd” in the Type box.

To totally unlock this section you need to Log-in

Login