Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

How to start the week in a Monday with this formula?

Hello,

I've tried using this formula however it recognises Sunday as the first day of the week. Is it possible to modify the formula in order to make it count monday as the first day of the week instead? Thank you

Edit:
Sorry I should have been more clear. I’ve already set up Monday as the first day of the week in my motion settings. The formula, however, still displays Sunday as the first day of the week (what I would consider last week, since Monday is the first day of the week in my settings). Showing me last week’s Sunday as part of this week.

1 Answer

0vote

polle Points77470

Showing if a day is in this week and having Monday as the start of the week are completely different things, that formula will not work for this.

Go to Notion settings, select Language & region and you have an option there to select start week on Monday.

1vote

sofsoberon commented

Sorry I should have been more clear. I’ve already set up Monday as the first day of the week in my motion settings. The formula, however, still displays Sunday as the first day of the week (what I would consider last week, since Monday is the first day of the week in my settings). Showing me last week’s Sunday as part of this week.

0vote

polle commented

Use uppercase W in the formula.

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect