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.

first day of the week account settings.gif


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.

First day of the week region settings.gif

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() , and DateTimeTruncate(date,"week") formulas now respect the new setting.

  • WeekNumber() always considers the first week of the year to contain Jan 1. Continue to use IsoWeekNumber() 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.

Did this answer your question?