Week numbers in LibreOffice Calc
To calculate the ISO 8601 week number in LibreOffice Calc, use the following formula:
=ISOWEEKNUM(A1)
* 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 =ISOWEEKNUM(A1) in another cell and press Enter.
- The ISO 8601 week number is returned.
Good to Know
Older LibreOffice versions (before 4.2) only had WEEKNUM with a mode argument; on current versions ISOWEEKNUM is the reliable choice and matches Excel's function name.