Help

Breaking down the month into weeks, regardless of dates

Topic Labels: Dates & Timezones
1205 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Amy_Roberts
4 - Data Explorer
4 - Data Explorer

Hello! I am wanting to create a field that will automatically add either “Week 1” “Week 2” “Week 3” Week 4" or “Week 5” depending on which week it is in the month, i.e. this week June 26th would be “Week 4”. Is there a formula I can use to create this?
Thank you!

2 Replies 2

Hi Amy, could you try this out?

WEEKNUM({Date})
-
WEEKNUM(DATETIME_PARSE(YEAR({Date}) & "-" & MONTH({Date}) & "-01", 'YYYY-MM-DD'))
+ 1

It’s set up here for you to check out as well

Amy_Roberts
4 - Data Explorer
4 - Data Explorer

Looks like it works, Thank you!!