none
Counting the Number of days since Project Kick off for each task RRS feed

  • Question

  • I'm a bit of a newbie to Project, so forgive me if this is simple.  I have a project plan that 318+/- entries long complete with estimated duration, start and end dates. I'm now being asked to provide these entries (in addition to the dates) in cumulative duration.  That is to say that is to say that they want to know how many after the projects kick off will this line item complete. 

    Does  a simple way exist?

    Sunday, July 3, 2011 11:52 PM

Answers

  • wbicknell --

    Create a custom task Duration field and name it something like Days from Start.  In this custom Duration field, enter the following formula:

    ProjDateDiff([Project Start], [Start], "Standard")

    This formula will calculate the difference between the current Start date of each task and the Start date of the entire project using the Standard calendar.  If your project is using any calendar other than the Standard calendar as the Project calendar (Project > Project Information), then enter the name of that calendar in the formula instead of the Standard calendar. In the Calculation for Task and Group Summary section of the dialog, be sure to select the "Use formula" option to force it to calculate Duration values for summary tasks.  Hope this helps.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Monday, July 4, 2011 12:29 AM
    Moderator

All replies

  • wbicknell --

    Create a custom task Duration field and name it something like Days from Start.  In this custom Duration field, enter the following formula:

    ProjDateDiff([Project Start], [Start], "Standard")

    This formula will calculate the difference between the current Start date of each task and the Start date of the entire project using the Standard calendar.  If your project is using any calendar other than the Standard calendar as the Project calendar (Project > Project Information), then enter the name of that calendar in the formula instead of the Standard calendar. In the Calculation for Task and Group Summary section of the dialog, be sure to select the "Use formula" option to force it to calculate Duration values for summary tasks.  Hope this helps.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Monday, July 4, 2011 12:29 AM
    Moderator
  • Dale is totally right, if you want to see this in action check out my blog on this... http://www.applepark.co.uk/displaying-the-day-count-for-a-task/ 
    Ben Howard [MVP] blog | web
    Monday, July 4, 2011 8:00 PM
    Moderator
  • This worked great.  Thanks so much.  The project schedule was perfect! 
    Wednesday, November 9, 2011 12:58 AM
  • wbicknell --

    You are more than welcome for the help, my friend!  :)


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Wednesday, November 9, 2011 1:11 AM
    Moderator
  • Do you happen to have the formulas to be able to produce similar information, but also for Early start, Early Finish, Late start, and late finish dates? But instead of the calendar dates it just shows the project date like you have explained above?
    Wednesday, March 11, 2015 9:01 PM
  • GreggggggggS --

    You will need to explain in more detail.  How many formulas do you need and what are they supposed to calculate?  Please let us know and we will try to help you.


    Dale A. Howard [MVP]

    Wednesday, March 11, 2015 10:21 PM
    Moderator
  • I already have these two formulas that display my project in terms of project day number instead of calendar days.

    Start: "Day " & ProjDateDiff([Project Start],[Start],[Project Calendar])/[Minutes Per Day]+1

    Finish: "Day " & ProjDateDiff([Project Start],[Finish],[Project Calendar])/[Minutes Per Day]+1

    I was wondering if you knew the formulas for the Late start and Late Finish dates? 

    Thursday, March 12, 2015 12:44 PM
  • Greg --

    Early Start, Late Start, Early Finish, and Late Finish are calculated by Microsoft Project using a forwards pass and a backwards pass through the project.  To the best of my knowledge, Microsoft has never released the formulas used to calculate those dates.  Perhaps someone else in this forum knows the formulas.  Hope this helps.


    Dale A. Howard [MVP]

    Thursday, March 12, 2015 1:05 PM
    Moderator
  • Greg,

    Pardon me for bumping in, but unless I misunderstood something, you asked for cumulative duration from project start to each task (line item) finish. I would take cumulative duration to be in calendar days, not working days. If that is the case then your formulas should be:

    Start: "Day " & DateDiff("d",[Project Start],[Start])+1

    Finish: "Day " & DateDiff("d",[Project Start],[Finish])+1

    Further, to calculate the same data for early start, early finish, etc., you don't need to know the formula Project uses to actually calculate those dates. All you need is to substitute those dates into the formula. For example, the cumulative days to a task's early start would be

    Early Start: "Day " & DateDiff("d",[Project Start],[Early Start])+1

    If you do want the cumulative time in working days, the the formula should be

    Start: "Day " & ProjDateDiff([Project Start],[Finish],[Project Calendar])/[Minutes Per Day]

    i.e. no "+1"

    John

    Thursday, March 12, 2015 4:41 PM