Re: Week numbers in a chart

2404 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

How do I revise this formula so that it gives me both the week # and the range of days in that week?

DATETIME_FORMAT({Date to work on it},‘ww’)

Also, is there a week to do a week number that doesn’t start over at the beginning of the year?

All I really want to do is be able to create either a chart or a pivot table that gives me the sum of an integer weekly over about eight weeks.


4 Replies 4

Hi Tobin, any chance you could provide some example data and the desired output?

Thanks Adam, I was actually able to get it to work. Thanks for the response though.




Would you mind sharing your solution for other community members who might be faced with the same problem? :slightly_smiling_face:

5 - Automation Enthusiast
5 - Automation Enthusiast
  1. 1st week
    2nd week
    3rd week
    4th week
    5th week
    6th week
    7th week
    8th week
    9th week
    10th week
    11th week
    12th week
    13th week
    14th week