Project Week Number by project start/end date


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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!