https://bugs.documentfoundation.org/show_bug.cgi?id=158845
Regina Henschel <rb.hensc...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
CC| |rb.hensc...@t-online.de
Status|UNCONFIRMED |RESOLVED
--- Comment #1 from Regina Henschel <rb.hensc...@t-online.de> ---
Please notice, that there exists several functions to calculate a week number:
ISOWEEKNUM
WEEKNUM
WEEKNUM_EXCEL2003
Notice, that functions WEEKNUM and WEEKNUM_EXCEL2003 have a second parameter
'Mode' to determine the start of a week and the calculation method.
If you do not need interoperability with older, foreign applications, you
should use IOSWEEKNUM which follows the 'ISO 1806' standard.
You are likely looking for WEEKNUM_EXCEL2003 with MODE=1 (Week starts on
Sunday) or MODE=2 (Week starts on Monday).
--
You are receiving this mail because:
You are the assignee for the bug.
