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
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
-
In that case you would use something along the lines of
=INT(([Date Column]@row - MIN(COLLECT([Date Column]:[Date Column], [Date Column]:[Date Column], @cell <> ""))) / 7) + 1
Answers
-
Where would this week number be populated exactly? Are you able to provide screenshots for context?
-
@Paul Newcome It would be populated in the project plan. Right now it is just for one report.
Goal is to show project week number alongside task start date, assigned to, estimated effort, and actual capacity for external clients.
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! -
On every row?
Are you concerned with the week numbers following specific days on the calendar (Monday to Sunday type of thing) or would the start of the week be based on the start of the project so that some would be Tuesday through Monday and others could be Friday through Thursday based on the day the project actually starts?
-
@Paul Newcome It would be based on the project start date and not a specific day of week.
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! -
In that case you would use something along the lines of
=INT(([Date Column]@row - MIN(COLLECT([Date Column]:[Date Column], [Date Column]:[Date Column], @cell <> ""))) / 7) + 1
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!