Day of the week from the date of charge - so it goes with OpenOffice Calc
In order to from a date of the corresponding day of the week calculate can, in OpenOffice Calc, first of all, a date.
- Select the cell or cells with a date from which you want to the corresponding days of the week can be calculated.
- Then click on "Format" > "cells...". There you can find various format categories. Here, select the entry "user-defined".
- Then, enter the following Format Code in the bottom line: "NN. TT.MM.YYYY"
- In the preview, you will see the new Format, for example "Di. 08.07.2014". If instead the Code "NNN. TT.MM.YYYY", it will be announced the day as "Tuesday 08.07.2014" is displayed.
- "OK" to confirm the formatting, finally.
Day of the week from date calculate
This practice tip applies to OpenOffice 4.1.0. You can with OpenOffice Calc by the way, even a date difference calculate.
