Using WEEKNUMBER formula between years
I use WEEKNUMBER to calculate the week number of the Start Date. For example, if my first project task is set to start on 05/01/2023, the formula is set to =WEEKNUMBER([Start Date]@row) - 17, which shows 05/01/2023 as week number 1. Subtracting the '17' is how we make week 18 week 1.
My issue is, if I make that a column formula, and the project carries over to the next year, the count starts over. So the first week of the year becomes '-16'.
Any ideas on how to circumnavigate and show that the first week in January of the following year is actual week 36?
Help Article Resources
Check out the Formula Handbook template!