Project Week Number by project start/end date

Options

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

https://www.linkedin.com/in/megyoungpm/

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!