Forum Discussion

Raskyl's avatar
Raskyl
Copper Contributor
Sep 27, 2022
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...
  • Martin_Weiss's avatar
    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)

Resources