Forum Discussion
Solved
Count up from a certain number weeks which carry on to next year
Hello, I want to understand if there is a way to count weeks starting from Tuesday. So the general gist of it is that I want to make a counter. it has already reached 100 weeks now and I'm trying...
Hi Raskyl
the WEEKNUM function has a second parameter where you can control the day a week should start with. If you use 12 as the second parameter, the week starts with Tuesday.
And you should not use strings in your IF-statement, because the YEAR function does not return a string but a number.
Try this one instead:
=WEEKNUM(A6,12)+IF(YEAR(A6)=2022,60,112)
Hi Raskyl
the WEEKNUM function has a second parameter where you can control the day a week should start with. If you use 12 as the second parameter, the week starts with Tuesday.
And you should not use strings in your IF-statement, because the YEAR function does not return a string but a number.
Try this one instead:
=WEEKNUM(A6,12)+IF(YEAR(A6)=2022,60,112)
AH this works beautifully! thanks a lot!