Forum Discussion
Raskyl
Sep 27, 2022Copper Contributor
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...
- Sep 27, 2022
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)
Martin_Weiss
Sep 27, 2022Bronze Contributor
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)