If you work a lot with Microsoft Excel, you may have faced the problem of being able to convert a date into a day of the week.
By default, this already works with the function
Weekday()
but unfortunately, this Excel function only returns the numbers 1-7 for the weekdays Sunday – Saturday. You would then have to convert these numbers into the corresponding day of the week in written form using another formula.
If you really want to calculate the day of the week in full form or in an abbreviation, you have to use the following Excel trick
CONVERT EXCEL DATE TO WEEKDAY
So that we can demonstrate this to you in the simplest way, we have also shown an example Excel file in the following figure. The Excel worksheet contains 2 dates that we now want to convert into a day of the week.
In line 2 we have shown the solutions to the individual date and weekday conversion formulas.
CONVERT DATE TO WEEKDAY LONG FORM
If you want to convert a date into a long-form weekday (Monday, Tuesday, Wednesday, etc.), all you have to do is use the following formula.
=TEXT(CELL, “tttt”)
As you can see, in column C the days of the week are calculated and displayed in their entirety.
CONVERT DATE TO WEEKDAY ABBREVIATION.
The same Excel date conversion into a weekday also works with the short form, i.e. in the representation of the weekday with 2 letters (Mon, Tue, Wed, Thu, Fri, Sat, Sun). This works with the almost identical weekday formula
=TEXT(CELL, “tttt”)
As you can see, it is very easy to convert a date or several dates directly into a day of the week in Excel.
