This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
@morgan@Aleksi
A little remark. I support this idea, in general, to set the day for the start of the week as per the user time zone. We have a couple of countries in the Middle East where the first day of the week is either on a Saturday, or Sunday, or Monday. And all of them supposed to use the same app, e.g. visit reporting. Please take this into account. Thx
It should work depending on your language settings in your device. For example if I choose Finnish as a language from the mobile phone, it shows Monday as a first day of the week which is correct.
Thank you for pointing me to this.
In the display the week starts on the Monday if you use Danish language on the phone.
But the calculation of Week stil think that the week starts on a Sunday.
I suggest you use the Language settings in the Sheet to set the start of the week, and use that information to calculate week no.