Skip to main content

Breaking down the month into weeks, regardless of dates

  • June 26, 2022
  • 2 replies
  • 28 views

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

TheTimeSavingCo
Forum|alt.badge.img+31

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


  • Author
  • New Participant
  • 1 reply
  • June 29, 2022

Looks like it works, Thank you!!