Week numbers in OpenOffice Calc
To calculate the ISO 8601 week number in OpenOffice Calc, use the following formula:
=WEEKNUM(A1; 21)
* Ensure your system or application regional settings are set to follow ISO 8601 standards (weeks start on Monday) if the output varies.
Step-by-Step Instructions
- Enter your date in a cell, for example A1.
- Type =WEEKNUM(A1; 21) and press Enter (note the semicolon argument separator).
- Mode 21 returns the ISO 8601 week number.
Good to Know
OpenOffice has no ISOWEEKNUM function; mode 21 of WEEKNUM is the ISO-compliant variant. Modes 1 and 2 use US-style numbering and will disagree around the turn of the year.