Hi everyone,
seems I do not know how to use the WEEKNUM() function since it seems to give me wrong numbers. And yes, this regardless of the additional parameter 1 or 2 (which accounts for the first day of week). More specifically: today we are living the week number 2 but WEEKNUM() function in Excel returns 3. Can anybody explain why and is there anywhere any cure for the ailment?
Of course there is the =WEEKNUM(now();2)-1 solution, but that is not what I am looking for...
Regards
Juha Antero