Excel: Weekday from date - this is how it works

If you need the exact weekday for a date, Excel offers you various ways to determine it from the available data. Which function you need for this and how you determine the weekday by menu from a date, we show you here.

Weekday from date: This is how the calculation is possible with the TEXT function

If there are dates in your Excel tables for which you would like to know the exact weekday, Excel offers you its own function for this with the "TEXT()" function.

1. To calculate the weekday from a date, please first select the cell in which the calculated weekday should appear.
2. Then enter the formula " =TEXT(A1; "TTTT")" in this cell and replace the placeholder "A1" thereby by the cell in which the date is located.
3. Confirm your input now still by pressing the "Enter" key, so that the result appears.
4. Alternatively, the calculation of the weekday is also possible without reference to a second cell, by entering the date directly into the formula "=TEXT(1.12.1988; "TTTT")".

How to format a date as a weekday in Excel

Without entering a formula, the conversion of a date into a weekday is also possible via the menu bar of Excel. To do this, first select the cell that contains the date and choose "More number formats" from the drop-down menu in the "Start" tab. In the window that opens, then navigate to "Number" > "Custom" and enter the value "tttt" in the "Type" field before confirming with "OK".