Begin date calculation based on (multiple) end date dependency

[Jacobs87]

Hi all,

I have an Excel challenge which I cannot get my head around. I have a planning sheet with multiple tasks and duration, which all have a start and end date. However. Some of the tasks are dependent on others. In other words: the start date of a task X could be dependent of task Y.

ID	Task	Duration	Start	End	Dependency task
1	A	2 weeks	1-1-2018	14-2-2018
2	B	1 week	14-2-2018	21-2-2018	2
3	C	2 weeks			2
4	D	3 weeks			2,3
5	E	1 week			3

<tbody>
</tbody>

Anyone with an idea?