https://bugs.documentfoundation.org/show_bug.cgi?id=139421
--- Comment #2 from Peter S Anderson <[email protected]> ---
Created attachment 168700
--> https://bugs.documentfoundation.org/attachment.cgi?id=168700&action=edit
Spreadsheet showing incorrect values of Weeknum
I have confirmed this bug in 6.4.7.2 and DEV although the results given in the
initial bug report are incorrect.
The bug notes that the text formatting function,
text(date-value, “WW”) is giving the incorrect result for the date 31/12/2020.
My reference documentation is
https://help.libreoffice.org/3.3/Calc/WEEKNUM
Here it states that week number 1 of any year is the week that contains January
4th.
The problem is that Jan 4 2020 was a Saturday and so Jan 5 2020 was the start
of week 2 of 2020 and week 53 starts on Dec 27 and ends on Jan 2. Week 1 of
2021 starts on Jan 3,
I have attached a spreadsheet that shows that there is a problem with both the
Weeknum function and the WW format from Dec 27 2020 and probably for most of
2021.
--
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
