Pretty easy to fix this inline without using a (custom) function...
Simply base your week calculation always of the Monday of that week, like so:
Edit: LOL, I gave this solution already on top of this page
Some 11 ! years ago... Hey I didn't get my 10 year anniversary cake 3 years ago!!!
Simply base your week calculation always of the Monday of that week, like so:
Code:
format(YourDate - (weekday(YourDate, 2) - 1), "YYYY/WW",2,2)
Edit: LOL, I gave this solution already on top of this page
Some 11 ! years ago... Hey I didn't get my 10 year anniversary cake 3 years ago!!!