Display Relative Week Numbers in MS Project
If you’d like to show the relative week number from the project start next to milestone tasks in the WBS of the Gantt chart. You need to insert a calculated text field with to handle this.
Right click on the column header
- Select “Insert Column.”
- Select an unused custom text field name like “Text1″.Â
- Change the title to something like “Week #”.
Now, you should see a blank column with the header “Week #” on it.Â
- Right click that new column header and choose “Customize Fields…”Â
- Click the “Formula…” button
- Type the following formula into the formula dialog:Â
- CStr(1+DateDiff(”w”;[Project Start];[Start]))