https://bugs.documentfoundation.org/show_bug.cgi?id=168576
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #1 from Mike Kaganski <[email protected]> --- https://docs.oasis-open.org/office/OpenDocument/v1.4/OpenDocument-v1.4-part4-formula.html#WEEKNUM > Syntax: WEEKNUM( DateParam D [ ; Number Mode = 1 ] ) It tells that mode 1 is the default, used when you don't explicitly specify the mode, as in your "=WEEKNUM(DATE(2025,12,31))". > For Mode = {1, 2, 11, 12, ..., 17} the week containing January 1 is the first > week of the year It means, that the week of 2025-12-31, which is the same week as for 2026-01-01, is week 1. (In reply to documentfoundation.crummy860 from comment #0) > If I am reading the standard wrong, then at least the documentation should > stop saying "compatible with other spreadsheet programs" when it does not "Compatible with other spreadsheet programs" does not contradict with "implements standard correctly". If there is a problem with the standard, you are welcome to file a request to OASIS (which Microsoft is member of). Not a bug. -- You are receiving this mail because: You are the assignee for the bug.
