Formula needed to show project week

Jez Akali

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

Paul Newcome

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.