Assign week number per month
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...