I was trying to group the weeks by the month, so like if I have a Date, I want to get the weeknum in which the date falls WITHIN that specific month only.
Eg. - 1/6/22 - it should show as 1 - since it comes in 1st week of June.
I read up and tried to use the following formula -
However, its giving the output as 6(?!) I think its because its counting 26th May till 2nd June as a week.