Kamal settled down, opened his laptop and said “Whatever I am learning here, I started applying most of the things in my project planning. My management is happy to see that things are getting more manageable now”.

“However, my manager want to know few things how it happens in MS Project” he continued, “How can I find number of days between project start date and task start date?”

He opened KidVentures.in case study and pointed what he wants.

How can I find number of days between project start date and task start date in MS Project 2013 - 1

For example difference between project start date is July 1, 2015 and a task ‘Develop Code’ start date August 14, 2015.

Yes, finding the difference between project start date and task start is possible with minor customization. There should be a custom field created to calculate and show that information for the user.

Following are the steps to achieve it.

Step 1: Go to Project Tab

Step 2: Click on custom fields

Step 3: Click task radio button

Step 4:  Select Type as duration

How can I find number of days between project start date and task start date in MS Project 2013 - 2

Step 5: Select any given duration field and rename it (e.g change Duration10 to MyDateDiff)

How can I find number of days between project start date and task start date in MS Project 2013 - 3

 

Step 6: Click formula button in custom attributes

Step 7: Enter formula as given below

ProjDateDiff([Project Start],[Start],[Project Calendar])

How can I find number of days between project start date and task start date in MS Project 2013 - 4

Step 8: Click ok

Step 9: Go to Gantt chart and add this custom field.

How can I find number of days between project start date and task start date in MS Project 2013 - 5

Step 10: Now this column shows the difference between the project start date and task start date for each task in the new column.

How can I find number of days between project start date and task start date in MS Project 2013 - 6

Take a closure look at the formula used ProjDateDiff([Project Start],[Start],[Project Calendar])

ProjDateDiff is function that gives the resultant in number of days that is equal to difference between two dates as according to selected calendar.

[Project Start] represents project start date.

[Start] represents task start date.

[Project Calendar] represents Calendar selected for project, e.g. standard calendar

 

Aforementioned formula can be changed based on the difference between dates user wants. e.g. If project is already baselined, then user may want to consider baseline start date of task instead of task start date. Now the formula becomes ProjDateDiff([Project Start],[Baseline Start],[Project Calendar])

If user wants to build new formula, then user can use the buttons, fields and function as accordingly.

How can I find number of days between project start date and task start date in MS Project 2013 - 7

Kamal appeared in next day class with all smiles and mentioned his manager was so happy to see management expectations addressed through this solution.

© Copyright 2017 www.24x7Coach.com. All rights reserved. 24x7Coach.com is a venture of Mahtia Business Solutions Pvt. Ltd.

24x7Coach.com is Authorized Training Partner of VMEdu, Inc. (ScrumStudy.com, SMStudy.com)

Registered Office: Mahtia Business Solutions Pvt. Ltd. West Marredpally, Secunderabad, Telangana, India
Classes held: Based on convenience - S R Nagar, Madhapur, Kukatpally

Microsoft is a Registered Trade Mark of Microsoft Corporation in the United States and/or other countries.
PSM, and Professional Scrum Master are trademarks of scrum.org. Content on our site is not affiliated with nor endorsed by Scrum.org.
Please report any IP violation or plagarism to info@24x7coach.com and we will act promptly and accordingly.

PayPal Acceptance Mark