KALENDERUGE_EXCEL2003(A6;Support.$C$2)
The function above gives me the weeknumber 02 if A6 = monday 4. of january 2021
That is wrong !! It should be week number 01 ???
It is a bit like 1980 being in the 20th century. If the week starts on Sunday then you are definitely into the second week, hence week 2. If the week starts on Monday, it is still the start of the second week.
Maybe that is why there is ISOWEEKNUM where it has been decreed that Monday shall be the first day of the week. A week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie. That means that week number 1 of any year is the week that contains the January 4th.
Cheers, Al
Well that’s all fine but ISOWEEKNUM does not work in the danish version !? WEEKNUM is KALENDERUGE in danish, but ISOKALENDERUGE throws an error ??
I found this thread also http://document-foundation-mail-archive.969070.n3.nabble.com/da-dansk-WEEKNUM-td4218659.html
- but none of the translations are working !!?? It is pretty imposible to gues what ISOWEEKNUM is in danish ?
EDIT: Sorry I got it now - it is called ISOUGENUM in danish - not very intuitive when WEEKNUM is called KALENDERUGE ??
If it throws an error and it is repeatable error then you should post a bug report, see Getting Started
BTW. Yours was not an answer so should have been a comment.
It seems to be the function ISOUGE.NR . BTW it doesn’t take a second parameter
ISOUGENUM will give nearly always the same result as KALENDERUGE_EXCEL2003. If you really want it to be ISOWEEKNUMBER then you need to use ISOUGE.NR
I can’t speak Danish but the online help makes it obvious, even giving the equivalent English name.
KALENDERUGE_EXCEL2003. gives wrong result for 4-1-2021 - it says week number 2 - which is wrong.
EDIT: Sorry I got it now - it is called ISOUGENUM in danish - not very intuitive when WEEKNUM is called KALENDERUGE ??
… and why do you use Danish function names, if you want intuitive, global and non-misleading names (Tools -> Options -> LibreOffice Calc -> Formula -> Option; [x] User English function names)?
funny that in a modern world so much frayed stuff accumulates so fast …
most likely it’s a fault or ‘in error use’ of ex$el, as ‘EXCEL2003’ indicates that the function is intended to simulate ex$el results,
either use ‘weeknum’ or better ‘isoweeknum’ instead (and google for their parameters regarding startday of week and ‘system1’ (first week starts jan 1.) or ‘system2’ (first week needs four days) for the numbering scheme), or
look at this similar question
and the help sheets linked there, @Lupp’s recommendations are mostly useful,
excel 2010 calculates correct with weeknum and ‘21’ for type,
calc also with weeknum type 21 and isoweeknum without type,
i have no excel 2003 at hand to recheck whether it does wrong or needs appr. parameters,
using english function names is often easier,
P.S. ‘solved marks’ and ‘likes’ welcome,
click the grey circled hook - ✓ - top left to the answer to turn it green if the problem is solved,
click the “^” above it if you ‘like’ the answer,
“v” if you don’t,
do not! use ‘answer’ to add info to your question, either edit the question or add a comment,
‘answer’ only if you found a solution yourself …