Much of the world doesn’t start calendar weeks on Sunday, so whether your week starts on Friday, Saturday, Sunday or Monday, you have the option to customize the first day of the week for your docs.
Set custom first day of week for all future docs
Maybe you want all your future docs to reflect the first day of the week for your region. You can update your settings for all your new docs in the New Doc Region Defaults. Click on your account settings in the upper-right hand corner of your screen and scroll down to the New Doc Region Defaults section. Here, you can select your time zone and your preferred first day of the week.
Note that this won't apply retroactively to existing docs.
Set custom first day of week for existing docs
To customize the first day of the week in your existing docs, click on the gear icon in the upper-right hand corner of your doc to open doc settings. Click Region and look for the First Day of The Week section at the bottom of the display panel. Select your preferred day from the drop-down.
Once you have made the changes, you will see your new first day of the week updated in other areas of your doc, such as date pickers and date controls.
Calendar options
Calendars will automatically follow the doc’s first day of the week setting. You can also access this setting by opening Calendar options > Calendar display. Then look for the First Day of The Week option at the bottom, and select Change to open the doc settings.
Formula tips
The
Weekday()
,WeekNumber()
, andDateTimeTruncate(date,"week")
formulas now respect the new setting.WeekNumber()
always considers the first week of the year to contain Jan 1. Continue to useIsoWeekNumber()
for the convention where the first week of the year includes the first Thursday of the year, and the first day of the week is Monday.We’ve also added
IsoWeekday()
which always considers Monday the first day of the week, regardless of doc setting.