OpenOffice Calc: Calculate the day of the week from the date
With OpenOffice Calc you can automatically calculate the day of the week from a date - we will show you how it works in just a few steps.
Calculate the weekday from the date - this is how it works with OpenOffice Calc
To be able to calculate the corresponding day of the week from a date, first enter a date in OpenOffice Calc.
- Select the cell or cells with a date from which you want to calculate the corresponding days of the week.
- Then click on "Format"> "Cells ...". There you will find various formatting categories. Select the "User-defined" entry here.
- Then enter the following format code in the lower line: "NN. DD.MM.JJJJ"
- In the preview you can already see the new format, e.g. B. "Tue 08.07.2014". If you use the code "NNN. DD.MM.YYYY" instead, the day will be displayed as "Tuesday, July 8th, 2014".
- Finally, confirm the formatting with "OK".
This practical tip relates to OpenOffice 4.1.0. By the way, you can even calculate date differences with OpenOffice Calc.