First day of the week Monday/Sunday

[Connor_McCormick1]

This is also relevant to this thread:

Find next Friday (or find next day of week)

…unless it’s already Saturday and it will show the previous one. Correct one would be: YourDate + Remainder(13 - YourDate.Weekday(), 7) if it should show the same day on Friday, and YourDate + Remainder(12 - YourDate.Weekday(), 7) + 1 if it should show the next one.