Feb
12
Display Relative Week Numbers in MS Project
Posted by Steve Wilheir under Gantt Charts, MS Project Tips
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 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 “C ustomize Fields…”
- Click the “Formu la…” button
- Type the following formula into the formula dialog:
- CStr(1+DateDiff(”w”;[Project Start];[Start]))
No related posts.
Related PostsNo related posts.
August 9th, 2008 at 3:28 pm
Hi,
As a project management blogger, would you be interested in being a guest blogger for The pm411.org Project Management Podcast website (www.pm411.org)? My subscribers would undoubtedly be interested in your viewpoint on any PM topic you choose and we would provide a link back to your site in the article to help drive additional traffic to your site.
May 8th, 2009 at 12:08 am
Hey, thanks…..
though this may have been a simple thing for you, it saved me a lot of time! Thanx!!
Supun
July 7th, 2009 at 3:58 am
I’m getting a syntax error. It doesn’t like the “w” bit. any ideas?
March 18th, 2010 at 2:57 am
Thanks for the tip. Seems that in Project 2000 I had to re-type the “w” and change the semicolons for commas, but I got the column working. Now what I want is to actually show a Gantt chart with relative dates, not aboslute. This is for estimates where I want to say – it will take this long with staging from the start date – whatever that start date turns out to be…..
Would be great if MS project could do that, but I suspect that it is another example of where MS project doesn’t work in the real world…
January 31st, 2011 at 8:40 pm
Great tip! I am often trying to calculate this by hand and that is really handy to have a way to put that in automatically!
Thanks.
February 3rd, 2011 at 11:19 am
Thanks for the tip! I’ve also created a second column and changed the [start] to [finish] so I can see which project weeks my tasks run over.
By changing my project start date, I have my start up tasks showing as -weeks and then the correct numbering for the project weeks.
Just what I was after!!