Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

PROJECT dates. HELP PLEASE!!!! 1

Status
Not open for further replies.

buscaquetebusca0

Civil/Environmental
Jun 23, 2010
2
0
0
ES
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.
 
Replies continue below

Recommended for you

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")

 
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
 
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.
 
Status
Not open for further replies.
Back
Top