https://bugs.documentfoundation.org/show_bug.cgi?id=147654
Bug ID: 147654
Summary: WEEKNUM function
Product: LibreOffice
Version: 7.1.8.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Today is 25th February 2022.
The first day of the year was a Saturday, so according to the ISO standard -as
used by Google calendar etc.) today should be week 8.
WEEKNUM
System 1 = The week containing January 1 is the first week of the year, and is
numbered week 1.
System 2 = The week containing the first Thursday of the year is the first week
of the year, and is numbered week 1. That means that week number 1 of any year
is the week that contains January 4th. ISO 8601 defines this system and that
the week starts on Monday.
The default is said to be 1, so =WEEKNUM(TODAY()) should return a value of 9,
which it does.
But =WEEKNUM(TODAY(),2) should return the ISO 8601 number, which is 8. In
fact, it also returns 9.
--
You are receiving this mail because:
You are the assignee for the bug.
