Project Based Template For Dates

[Kumara_faith]

Hi,

I have a table as attached for a project. Usually the first task will not have any dependencies. However, task 2 has a dependency in which task 2 can only start after task 1 has been completed. In the example attached, task 1 is completed on 7/16/2015. Therefore the start date for task 2 should automatically populate as 7/17/2015.The formula in the start date should also exclude weekends and public holidays. Is there any way to accomplish this ?


Any help will be greatly appreciated.

I have a cross post here:

http://www.mrexcel.com/forum/excel-q...ate-dates.html