AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
5.6K members online now
5.6K members online now
Ask questions about Data Studio
Guide Me

Week Commencing Date

Follower ✭ ✭ ✭
# 1
Follower ✭ ✭ ✭

I need to round dates to the nearest Monday of that week, ie Wednesday 12th April 2017 would become Monday 10th April 2017.


Has anyone done this? I'm assuming there is a way by making the date a 'week number', week() rounding down, Round() and making it a date again? Or similar method?