Question

Excel: Determine the day of the week from the date - this is how it works

Answer 1

How to calculate the day of the week of a date in Excel

---

Excel offers many different formulas for calculating a variety of things. For example, the day of the week for a specific date..

What day of the week was November 14th, 2020? Was it a Monday, Tuesday, Wednesday, etc ...? If you want to know what day of the week a certain date fell on, you can easily find out the day in Excel. We'll show you how it's done.

How to calculate the day of the week of a date in Excel

With the Excel function TEXT you can convert numbers into text and apply formatting to these numbers. It is therefore ideal if you want to determine the day of the week for a date. Since dates are actually only sequential numbers, you can use this function to convert any date into a text string with the format for days of the week.

The syntax for the TEXT function is as follows:

=TEXT(Wert;Format)

• Value (required): This is the value to be converted to a text string, such as a specific cell that contains the date.
• Format (required): This is the formatting to be applied when converting to a text string.

In our example, we now want to determine the day of the week for the date 11/14/2020, which is in cell B2.

=TEXT(B2;"TTTT")
To do this, we use the following formula: This formula converts our date value in cell B2 to the corresponding day of the week. So here we get the value Saturday. If you specify only " TTT " for the format instead of " TTTT " , the abbreviated name of the day of the week is returned, as you can see in cell D3.

---