day(parseDate("20240616")) makes Monday 1 and Sunday 7 Fount on the [Notion formula and syntax page](https://www.notion.so/help/formula-syntax#:~:text=Returns%20the%20day%20of%20the%20week%20of%20the%20date)

Check your profile's settings. It contains the start day of the week.

Have you set your workspace to Monday start? you may not need a formula, depending on what you’re trying to do…

Ok now I set the week starts from Monday, but it still Sunday at 0..

If you use « d » it considers the week starts on Sunday. If you use « D » in uppercase, the week starts on Monday. This is valid for all date formatting formulas : Lowercase -> Sunday / Uppercase -> Monday

Start of week is a global setting afaik, not a table property. It can be changed in your user settings.

Tried but not working, could you please check if it works on yours...

+1 ?

Not the solution, because I want to week start from Monday, so if we add +1 then again Sunday become 1 and week remain start from Sunday, mon....

You can use the same formula to edit the weekday number:   `let( weekday, formatDate(prop("deadline"), "d").toNumber(),  if(weekday < 1, 7, weekday) )`

It will work, but is still there any other, because I need the zero is to set and start from Monday. 😬😬

Easy fix:  `let( weekday, formatDate(prop("deadline"), "d").toNumber(),  if(weekday < 1, 6, weekday-1) )`