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.

  1. Click File > Spreadsheet settings

Spreadsheet settings

  1. Select United Kingdom or other locale which start week on Monday

enter image description here enter image description here

  1. You're all set

enter image description here

  • Not 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" – Malcolm Anderson Dec 9 '19 at 3:27
  • Not good for me either. English (UK) is not available to choose from. – J. Doe Feb 23 '20 at 9:07
  • 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. – Bdoserror Feb 28 '20 at 8:37
  • It has nothing to do with anything related to a specific spreadsheet, because I viewed the same cell in the same spreadsheet from different accounts and the start of the week was different between them. – Tharkon Apr 7 '20 at 10:43
  • It 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. – Tharkon Apr 7 '20 at 10:54

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. :( – marikamitsos Feb 23 '20 at 23:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.