Excel: Calculate the day of the week from the date

With Excel you can automate many useful things. Among other things, a day of the week can also be calculated from a date. We show you how this works in this practical tip.

Excel: Calculate the day of the week from the date - how it works!

To convert a date into a day of the week, you only have to enter a certain formula. Excel then does the actual calculation:

• Enter a date in any field.
• Now enter the formula "= TEXT (field;" TTTT ")" in any other field (see screenshot).
• In the example, "field" corresponds to "A1", so the formula here is "= TEXT (A1;" TTTT ")". If you confirm with "Enter", the day of the week appears (here: Saturday).

This practical tip shows you how to calculate a checksum in Excel.