Show days elapsed from project start for each task / WBS element?

[Mike R.]

Is there a way to have a column that displays the number of days from Project
start to the start of a task?

I would like to show that WBS 3.2.1, on Line 500, starts X days after the
project starts. Then show 3.2.2, on line 501, starts y days after the project
start.

Can this be done??

Thanks,
Mike R.

 

[Andrew Lavinsky]

If you want to count work days:

Use the following formula in a custom duration field:
ProjDateDiff([Project Start],[Start])

If you want to count calendar days (including weekends/holidays):
ProjDateDiff([Project Start],[Start], "CountCalendar")

Where "CountCalendar" is a custom calendar created as a copy of the Standard
calendar, but w/ the weekends being Nondefault Working Time. There's probably
an easier way of accomplishing the latter, but that was the one that worked
for me.

-A

 

[Mike R.]

Andrew - you're a genius!! That did it. I did
"ProjDateDiff("11/15/06",[Start])" to count work days from my "work start"
date rather than the date in Project Start, and it worked perfectly. The
folks here think I'm very smart, when all I know is to ask smart people!!

Mike R.

If you want to count work days:

Use the following formula in a custom duration field:
ProjDateDiff([Project Start],[Start])

If you want to count calendar days (including weekends/holidays):
ProjDateDiff([Project Start],[Start], "CountCalendar")

Where "CountCalendar" is a custom calendar created as a copy of the Standard
calendar, but w/ the weekends being Nondefault Working Time. There's probably
an easier way of accomplishing the latter, but that was the one that worked
for me.

-A

Is there a way to have a column that displays the number of days from
Project start to the start of a task?

I would like to show that WBS 3.2.1, on Line 500, starts X days after
the project starts. Then show 3.2.2, on line 501, starts y days after
the project start.

Can this be done??

Thanks,
Mike R.

 

[Trevor Rabey]

Andrew - you're a genius!! That did it. I did
"ProjDateDiff("11/15/06",[Start])" to count work days from my "work start"
date rather than the date in Project Start, and it worked perfectly. The
folks here think I'm very smart, when all I know is to ask smart people!!

Mike R.

If you want to count work days:

Use the following formula in a custom duration field:
ProjDateDiff([Project Start],[Start])

If you want to count calendar days (including weekends/holidays):
ProjDateDiff([Project Start],[Start], "CountCalendar")

Where "CountCalendar" is a custom calendar created as a copy of the Standard
calendar, but w/ the weekends being Nondefault Working Time. There's probably
an easier way of accomplishing the latter, but that was the one that worked
for me.

-A

Is there a way to have a column that displays the number of days from
Project start to the start of a task?

I would like to show that WBS 3.2.1, on Line 500, starts X days after
the project starts. Then show 3.2.2, on line 501, starts y days after
the project start.

Can this be done??

Thanks,
Mike R.

Another handy way to count days is to make a Task, call it "elapsed
days" or whatever, give it a duration in edays, then link the start and
finish date to whatever dates you want to mention and make a Hammock.


Trevor