Feb
12
Display Relative Week Numbers in MS Project
Posted by Gantt Chart 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.
September 25th, 2008 at 8:35 am
\”I have to pay you a huge compliment and say that in reading your posts and your blogroll you didn\’t fit into one category. I say it\’s a compliment because some of the best sites on the left, center, and right aren\’t always predictable.
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…