WeekNumber Across Years

I have been able to find success at using the weeknumber formula and combining that with a 'past due' vs 'due this week' vs 'due next week' indicator. I have a separate sheet that identifies what 'this week' vs 'next week' vs 'last week' is by week number so that I just need to change it in 1 place for all of my projects. Its been working great. Now that we're approaching January though, it no longer works. Anything in January is showing past due since the Week Number changes to 1. Any ideas on how to report something similar across years?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!