Deduce Week Number (of 52) from Date Field

[Tobin_Perry]

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.

Thanks!

[TheTimeSavingCo]

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

[Tobin_Perry]

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

[Databaser]

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

[Rudolph_Hoffman]

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