PROJECT dates. HELP PLEASE!!!!

Question

PROJECT dates. HELP PLEASE!!!!

buscaquetebusca0 (Civil/Environmental)

(OP)

23 Jun 10 05:56

Hi. At first, sorry, my english isn´t very gook, I know.
OK, I´m working with "Microsoft project 2002". I need to know START and FINISH date for every task referred to START PROJECT DATE.
When the project begins, it´s "DAY 1", the next day is "DAY 2"...
For example, a task begins at DAY 45, and finishes at "DAY 48".
Anybody knows how I could know that automatically, for all tasks?
Thanks a lot.

bacon4life (Electrical) · Answer 1 · 2010-07-02 20:26:43

I have 2007 instead of 2002, so I am not sure if it will work in your version.

In one of the custum duration fields, enter a formula such as:

projDateDiff([Project Start],[Start],"24 Hours")

betonboer (Civil/Environmental) · Answer 2 · 2010-07-26 15:23:13

Can it be solved by adjusting the time-scaling and labels to count from projectstart. You then can easily see the daynumber in your gantt

buscaquetebusca0 (Civil/Environmental) · Answer 3 · 2010-07-28 11:02:26

Ok, thanks for your tips.
I solved my problem.

I entered a formula, but before I did the next:
I create a new calendar, named "natural", with all days like "working days".
I created two new columns: "starting", with "number1" and "finishing", with "number2".
I defined the next formulas:
For "number1":
ProjDateDiff([Project start];Start;"Natural")/(60*8)
For "number2":
ProjDateDiff([Project start];Finish;"Natural")/(60*8)
So, for every task I have in column1 start date referred to project start date and in column2 finisth date referred to project start date...

Ok thanks a lot.

Come Join Us!

Posting Guidelines

PROJECT dates. HELP PLEASE!!!!