weeknumbers 2020/2021 in Numbers

At our place of employment, we follow Europe weeks, so week one would start on January 4 if I choose Monday as my first day of the week. This is easy to choose in outlook by choosing the option "first four-day week". Can apple have the same option or a fix so our work iphones match our outlook calendars?

I just spent 30 minutes looking at the various date systems and how they do week numbers. Under none of them that I found is a week anything but 7 days. The algorithm here always makes Jan 1 start week 1, which would be okay in the Northern American system except that the days in December that start that week should also be week 1 (which they are not) and there should be 7 days to all weeks (which there are not). I'd say this function is broken. You can put in a bug report using the menu Numbers/Provide Numbers Feedback.

I'm going to wait to see if anyone else comes up with something that explains it as anything but a bug. I suppose it could be a function that does not mean what we think it means. We expect it to be following a standard but nowhere in the description of the function does it mention a standard.

EDIT: Stupid me, this is an Excel thing. It is a function compatible with Excel's function of the same name and gives the same results. So there you go. Not a bug, just a function that does not do what we thought it should do. Excel's version does, however, let you specify first day as Monday AND using the ISO system. Numbers does not allow that same thing.

Hi Kimberly,

Rewriting the software is beyond the scope of the participants in these user to user communities.

Use the Provide Numbers feedback menu item i the Numbers menu to request a feature enhancement or to Report a bug, whichever seems more appropriate.

REgards,

Barry

Excel has an ISOWEEKNUM function that does what you want.

Numbers doesn't have that function. But you can calculate the equivalent of the Excel function with this long formula:

The formula in C2, filled or copied down the column, is:

=INT((STRIPDURATION(A2−DATE(YEAR(A2−WEEKDAY(A2−1)+4),1,3))+WEEKDAY(DATE(YEAR(A2−WEEKDAY(A2−1)+4),1,3))+5)/7)

Be sure to include the final ) which seems to be cut off by the forum software.

Here it is again (it scrolls left so you can see and select the whole thing for copy-pasting).

INT((STRIPDURATION(A2−DATE(YEAR(A2−WEEKDAY(A2−1)+4),1,3))+WEEKDAY(DATE(YEAR(A2−WEEKDAY(A2−1)+4),1,3))+5)÷7)

If your region uses , as a decimal separator be sure to substitute ; for , in the formula.

If your Numbers is not normally set to English you could start a new document, switch to English via File > Advanced > Language & Region ... then copy/paste the formula from this post into your table, adds dates in a column to make sure the formula is working, then switch back to your language via File > Advanced > Language & Region. Numbers will automatically convert the formula to what you need to use in your language/region.

SG