Assigning a numeric value to a month

[Mark]

I want the first month of a schedule to have a value of "1", the second month
a value of "2"....and so on.... I need this to show up in a field in the
GANT chart.

 

[Mike Glen]

Hi Mark,

Welcome to this Microsoft Project newsgroup

Try Tools/Options.../View tab, Date Format and select 1/W05 to get a
numerical count, and for the Gantt Chart, try Format/Timescale.../ select
the Label you want.

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on )

Mike Glen
MS Project MVP

 

[Mark]

I'm not sure what the 1/W05 format give you....

What I need is if the project starts on 1-May-05, all tasks that start in
May-05 will have a value of "1". All tasks that have a start date in Jun-05
will have a value of "2"...so on.

Thanks....this forum is great !!!

 

[Mike Glen]

Try it, Mark, and see


Mike Glen
Project MVP

 

[JulieS]

Hi Mark,

Not sure if this is what you are looking for, but here's a suggestion:
Insert one of the spare number columns into the Task sheet. Create a
formula for the column of :
Month([Start])
This will return 1 for January, 2 for February etc. If your project starts
in May change the formula to:
Month([Start])-4
to get May equal to 1.
Hope this helps. Let us know how you get along.
Julie