Project Week Number by project start/end date

Meg Y
Meg Y ✭✭✭✭✭✭

I am needing to calculate actual project week number as majority of projects cross multiple years.

The current WeekNumber formula goes by calendar year, therefore resets each January.

Project start - 12/04/2023 / Project end - 03/10/2025

12/04/2023 = week 1

03/10/2025 = week 56

Meg Young
mmyoungconsulting@gmail.com

If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!