I found this formula here that has been working OK but I need to adjust it slightly and I’m not sure how.
VALUE(DATETIME_FORMAT({Show Date},‘w’))-
VALUE(DATETIME_FORMAT(DATETIME_PARSE(‘01’&DATETIME_FORMAT({Show Date},‘MM’)&YEAR({Show Date}),‘DDMMYYYY’),‘w’))+1
This gives me week numbers per month and then resets for the next month but I need Sunday to (and including) Saturday to be assigned the same week number. The way this formula is working right now, Saturday is being assigned to a new week. For example…
1st Sunday-Friday of the month = week 1, Saturday starts week 2
I hope this makes sense.