https://bugs.documentfoundation.org/show_bug.cgi?id=139548
--- Comment #1 from Uwe Auer <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
