Formula needed to show project week
Hi all,
I'm trying to put a project week column in my timeline, and I need it to return the actual project week and not the calendar week when looking at the start to finish date.
Example:
If my project started on 31/10 this will be week 1.
The formula looks at the task start and finish date and returns - 1,2,3. This is because the task is from 31/10 to 18/11.
Thanks in advance,
Jez
Answers
-
We can get it to display the start and finish week numbers, but not the numbers in between.
Basically you would take the number of days between the start of the task and the start of the project, divide that by seven, and then ROUNDUP to get the starting week number. You would do the same with the end date of the task to get the ending week number.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives