How do I get the start date of current week?

Ask for Help
2

image

Start of last week:

N-WEEKDAY(N)+2-7-HOUR(N)/24-MINUTE(N)/1440-SECOND(N)/86400

Start of this week:

N-WEEKDAY(N)+2-HOUR(N)/24-MINUTE(N)/1440-SECOND(N)/86400

With N being the “Now” value. Assuming you start the week on Mondays.

3 Likes