Setting Start dates based on dependencies

[nehamittal03]

Hi,

I have this spreadsheet which has tasks with one or more dependencies. These tasks can begin only after their dependencies are complete i.e. start date of task > max of end dates of its dependencies.

I need to validate the start date of all the tasks which have dependencies based on above logic. Is it possible to write a macro for this? Thanks in advance for help.

The spreadsheet I'm talking about looks something like this:

[TABLE="class: grid, ******* 696, align: left"]
<tbody>[TR]
[TD]Task Ref[/TD]
[TD]Task[/TD]
[TD]Start Date[/TD]
[TD]Target End Date[/TD]
[TD]Dependencies[/TD]
[/TR]
[TR]
[TD]A.1[/TD]
[TD]Obtain internal approvals[/TD]
[TD]10/1/2015[/TD]
[TD]8/1/2016[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A.2[/TD]
[TD]Obtain approval from the Committee[/TD]
[TD]11/1/2015[/TD]
[TD]12/9/2015[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A.3[/TD]
[TD]Determine whether something is established[/TD]
[TD]1/1/2016[/TD]
[TD]6/30/2016[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A.4[/TD]
[TD]Update database[/TD]
[TD]10/1/2016[/TD]
[TD]12/1/2016[/TD]
[TD]Obtain internal approvals
Obtain approval from the Committee
Determine whether something is established[/TD]
[/TR]
[TR]
[TD]A.5[/TD]
[TD]Inform Some one[/TD]
[TD]10/1/2016[/TD]
[TD]10/1/2016[/TD]
[TD]Update database[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col></colgroup>[/TABLE]