formula to caculate depedancies and start dates?

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
2,572
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Hi Everyone,
I'm putting toghther a very simple Gantt chart for a project.
I have 6 different parts to the project.
each part is seperated by a Project Number
so project 1 has 1, 1.1, 1.2, 1.3 etc.
The project numbers are in Column C
In Column D I have start date of the projects and in Column E the duration (not including weekends)
I want to caculate the actual start date of each part?

so heres my problem,
how can I caculate the start dates and end dates for each part? (Taking into account weekends not worked)

Below is a small example of what I have as I think visual will help.

ABCDEFGHIJKLMN
1PROJECT NAMEPROJECT NUMBERSTART DATE OF PROJECTDURRATIONACTUAL START DATEEND DATE
2Tony 111/1/1951/1/195/1/19
3tony1 dependency 11.156/1/1911/1/19
4
tony1 dependency 2
<strike></strike>
1.2212/1/1914/1/19
5
tony1 dependency 3
<strike></strike>
1.3315/1/1918/1/19
6Tony 223/1/19103/1/1913/1/19
7
tony2 dependency 2
<strike></strike>
2.1514/1/1919/1/19
8
tony2 dependency 1
<strike></strike>
<strike></strike>
2.1814/1/1922/1/19
9
tony1 dependency 4
<strike></strike>
1.3215/1/1917/1/19
10
11
12
13
14
15
16
17
18
19

<tbody>
</tbody>

so hopefully above you can see what I need to caculate,
my example dose not take into accpunt weekdays but should,
I can add extra columns if need be.
as you can see the parts wont allways follow each other so a part of project 1 can show up after project 2 and there can be more than one 1.1 for example but this would only happen if there was no number after it.

please help if you can as i'm very stuck

thanks
Tony
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Drrellik

Well-known Member
Joined
Apr 29, 2013
Messages
766
Office Version
  1. 365
  2. 2016
  3. 2013
  4. 2011
  5. 2010
Platform
  1. Windows
Actual Start Date is in column F if you are calculating F what data are you using? the end date minus duration? not sure what you are trying to populate based on a formula

~DR
 

Watch MrExcel Video

Forum statistics

Threads
1,108,704
Messages
5,524,416
Members
409,576
Latest member
az168

This Week's Hot Topics

Top