[Libreoffice-bugs] [Bug 139342] LibreOffice counts weeknumbers wrong, starting in 2021...

[bugzilla-daemon at bugs.documentfoundation.org]

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

Regina Henschel <rb.henschel at t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |rb.henschel at t-online.de
         Resolution|---                         |NOTABUG
             Status|NEW                         |RESOLVED

--- Comment #4 from Regina Henschel <rb.henschel at t-online.de> ---
The function WEEKNUM has a second parameter to determine, which calculating
system to use. For getting ISO system, you need mode 21.
=WEEKNUM(DATE(2021;1;1);21)
https://help.libreoffice.org/7.2/en-US/text/scalc/01/func_weeknum.html?DbPAR=CALC#bm_id3159161

Or you use directly ISOWEEKNUM.
=ISOWEEKNUM(DATE(2021;1;1))
https://help.libreoffice.org/7.2/en-US/text/scalc/01/func_isoweeknum.html?DbPAR=CALC#bm_id3159161

-- 
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/20201231/1cc80911/attachment.htm>