Day of Week Excel tutorial - how to get the day of week

This is a guide on how to get the day of week by date in Excel. Just follow these simple steps and you are good to go.

Type a date, for example 1.1.2012 in cell A1. Let's get a corresponding day of week by this date.


You can use the WEEKDAY function, which will give us a number representing the day of the week (monday = 1, tuesday = 2, wednesday = 3, etc.). Click on cell B1 and type following function:
WEEKDAY(A1) 
Now we hava a number representing the day of week in cell B1. How to turn the numbers into actual weekdays?

Right click on the cell and choose format cells. In the opening dialogue, select the last option "custom" and type DDDD to the field shown in the image shown below. Hit enter. This will give you the full name of the week. DDD will give the abbreviation (mon, tue, wed.. etc).

Day of Week Excel tutorial - how to get the day of week

2 comments: