Spot on Year/week_number(s) calculations

If you are looking for an explanation of the formula, I break it down in the following post. The formula I gave you is a spin off of the core formula I’ve always used. It’s an old post and I’ve tweaked the math over the years to account for leap years and leap centuries. (None of which matter in your case.) This math has been used by many and proven over the past few years. It’s complex to explain, but makes sense once you take the time to understand it.

1 Like