[Libreoffice-bugs] [Bug 139548] =WEEKNUM(xxx; 2) Returns Wrong Week Number for 2021

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139548

--- Comment #1 from Uwe Auer <uwe at franke-auer.de> ---
Documentation
https://help.libreoffice.org/7.0/en-US/text/scalc/01/func_weeknum.html?&DbPAR=WRITER&System=UNIX
states:

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.

And the table below shows the following modes for System 2

> System 2    21   Monday (ISO 8601)
>             150  (ISO 8601, for interoperability with Gnumeric)

Hence you need Mode=21 (not Mode 2, which is a mode of System 1) and you'll
get:

Date DD.MM.YYYY)        Weeknum Formula
01.01.2021      53      =WEEKNUM(A2;21)
02.01.2021      53      =WEEKNUM(A3;21)
03.01.2021      53      =WEEKNUM(A4;21)
04.01.2021      1       =WEEKNUM(A5;21)
05.01.2021      1       =WEEKNUM(A6;21)
06.01.2021      1       =WEEKNUM(A7;21)
07.01.2021      1       =WEEKNUM(A8;21)

>From my point of view: Not a bug

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210111/ec219af3/attachment.htm>