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

  1. Select “Insert Column.”
  2. Select an unused custom text field name like “Text1″.
  3. Change the title to something like “Week #”.Now, you should see a blank column with the header “Week #” on it.
  4. Right click that new column header and choose “Customize Fields…”
  5. Click the “Formula…” button
  6. Type the following formula into the formula dialog:
    • CStr(1+DateDiff(”w”;[Project Start];[Start]))
« Mac Gantt Chart Tool Review - Merlin 2.5
Work, Wages and Profits by Henry Laurence Gantt »

This entry was posted on Tuesday, February 12th, 2008 at 11:38 am and is filed under Gantt Charts, MS Project Tips. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

2 Responses to “Display Relative Week Numbers in MS Project”

  1. Ron Holohan says:
    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.

  2. John Sponterelli says:
    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.