I'm thinking you can get the expectation by using =Weeknum(now()) as long as
you're OK with it resetting each year and you start with the calendar year.

Would that work, or do you need something a little more sophisticated?