Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

PROJECT dates. HELP PLEASE!!!! 1

Status
Not open for further replies.
buscaquetebusca0

buscaquetebusca0

Civil/Environmental
Jun 23, 2010
2
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

Sort by date Sort by votes
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")

 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

e74222
  • Locked
  • Question
Calendars in Microsoft Project
Replies
1
Views
1K
IRstuff
IRstuff
e74222
  • Locked
  • Question
SSI tools for Microsoft Project
Replies
0
Views
997
e74222
e74222
Elimelech
  • Locked
  • Question
Ensuring Consecutive Task Scheduling in MS Project
Replies
0
Views
999
Elimelech
Elimelech
e74222
  • Locked
  • Question
Construction project with different phases under the same contract
Replies
0
Views
771
e74222
e74222
Asmaa Norway
  • Locked
  • Question
Help request with an example of pipeline spools and wyh structure project schedule
Replies
2
Views
1K
EduardSzigeti
EduardSzigeti

Part and Inventory Search

Sponsor

Back
Top Bottom