6

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.

2
  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

6
  • 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
  • 1
    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
  • 1
    Confirmed 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! – Erik Wool Dec 6 '20 at 20:44
1

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).

1
  • Welcome and sorry. Your answer has nothing to do with the question asked. :( – marikamitsos Feb 23 '20 at 23:24

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