Sometimes you don’t want to throw hard dates around when communicating project timelines. For example, when the customer writes a check, the project will take a certain amount of time, but the customer could delay for months as they do comparative analysis of buy vs. build, etc. Here’s a handy tip when you want to draw a Gantt chart , 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 in order to show week numbers in MS project.
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]))
Then you will see the relative number of weeks instead of dates in Microsoft project in your new column. Just hide the date column if you don’t want to show it.Related Posts