formula to caculate depedancies and start dates?

[tonywatsonhelp]

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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]PROJECT NAME[/TD]
[TD][/TD]
[TD]PROJECT NUMBER[/TD]
[TD]START DATE OF PROJECT[/TD]
[TD]DURRATION[/TD]
[TD]ACTUAL START DATE[/TD]
[TD]END DATE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Tony 1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1/1/19[/TD]
[TD]5[/TD]
[TD]1/1/19[/TD]
[TD]5/1/19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]tony1 dependency 1[/TD]
[TD][/TD]
[TD]1.1[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]6/1/19[/TD]
[TD]11/1/19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]

tony1 dependency 2​

[/TD]
[TD]<strike></strike>
[/TD]
[TD]1.2[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]12/1/19[/TD]
[TD]14/1/19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]

tony1 dependency 3​

[/TD]
[TD]<strike></strike>
[/TD]
[TD]1.3[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]15/1/19[/TD]
[TD]18/1/19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Tony 2[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]3/1/19[/TD]
[TD]10[/TD]
[TD]3/1/19[/TD]
[TD]13/1/19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]

tony2 dependency 2​

[/TD]
[TD]<strike></strike>
[/TD]
[TD]2.1[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]14/1/19[/TD]
[TD]19/1/19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]

tony2 dependency 1​

<strike></strike>
[/TD]
[TD]<strike></strike>
[/TD]
[TD]2.1[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]14/1/19[/TD]
[TD]22/1/19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]

tony1 dependency 4​

[/TD]
[TD]<strike></strike>
[/TD]
[TD]1.3[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]15/1/19[/TD]
[TD]17/1/19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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

 

[Drrellik]

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