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 Answers 2

3

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. :( Feb 23, 2020 at 23:24
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

7
  • 1
    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" Dec 9, 2019 at 3:27
  • Not good for me either. English (UK) is not available to choose from.
    – J. Doe
    Feb 23, 2020 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, 2020 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, 2020 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, 2020 at 20:44

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