How to set Monday as start day of the week in Google Sheets date picker?
I have changed the locale, changed start day of the week in Google Calendar and can't find a way to solve this.
Add a comment
|
2 Answers
WEEKNUM(date, [type])
date - The date for which to determine the week number. Must be a reference to a cell containing a date, a function returning a date type, or a number. type - [ OPTIONAL - default is 1 ] - A number representing the day that a week starts on as well as the system used for determining the first week of the year (1=Sunday, 2=Monday).
-
Welcome and sorry. Your answer has nothing to do with the question asked. :( Feb 23, 2020 at 23:24
- Click File > Spreadsheet settings
- Select United Kingdom or other locale which start week on Monday
- You're all set
-
1Not a good answer for me. Unless you know of a country where both Monday is the first day of the week and they use the dollar sign ($) for their currency. Kind of weird that Google linked all that into "location" Dec 9, 2019 at 3:27
-
-
I'm trying to get the opposite effect (Sunday for start of the week) and I've got my local set to the United States but I still get a calendar starting weeks on Monday. Feb 28, 2020 at 8:37
-
1It turns out that the link in the above answer (myaccount.google.com/language) is not actually spreadsheet related even though it is in Spreadsheet Settings. I can also add that it does not affect the date and currency notations in the spreadsheets because those are spreadsheet related. I can confirm that both English (United Kingdom) and English (Netherlands) result in Monday going back to its proper position on the left.– TharkonApr 7, 2020 at 10:54
-
1Confirmed that changing locale from English (UK) to English (US) does change week start day from Monday to Sunday. You must reload the page in order to see the change! Dec 6, 2020 at 20:44