Select the date range that you want to convert to day of week. Click on the long date format and the sample box will show a preview that includes the day of the week.
Input one of the following formats in the type box.
How to get day of the week in excel. Calculate the abbreviated weekday name. Return day of the week from date with format cells command the format cells command also can help you to finish this job. Date required the date to find the weekday number from.
Click the custom category in the format cells window. 2 returns 1 for monday through 7 for sunday. To get the day name i e.
The weekday function in excel returns a number from 1 sunday to 7 saturday representing the day of the week of a date. Monday tuesday etc from a date as text you can use the text function. If you want to get the day name from a date in excel you can use the text function with a specified format code like ddd or dddd.
In cell b1 enter text a1 ddd into the cell or formula field. Apparently 12 18 2017 falls on a monday. In this example ddd becomes wed.
Omitted or 1 returns 1 for sunday through 7 for saturday. Text date ddd text date dddd. In the example shown the formula in cell c4 is.
We can try to use the below text formula in excel. You can also apply a custom number format to just display the weekday name in the cell. Get day of week from date by format cells in excel you also can use the format cells to change dates to weekday format.
The date must be in a form that excel recognizes as a valid date. Select the date cells you want to change and right click to select format cells from the context menu. The ddd setting tells excel to use the first three letters of the weekday name.
In the example shown the formula in cell b5 is. Type optional the weekday number type to return.