VBA for variable date

[cdantonelli]

Setup:

Title of task Projected Start Date Block per day Projected Duration in Hours Projected days of work
A1 Sweep floor B1 10/19/2015 C1 .05 / day D1 18.25 E1 4
A5 Cut Grass B5 10/23/2015 C5 .05 / day D5 16.00 E5 4

Obviously sweeping the floor can take more or less time than 18.25 hours, so i am looking for a code that will make

A1 Sweep Floor B1 - 10/19/2015
B2 - 10/20/2015
B3 - 10/21/2015
B4 - 10/22/2015
B1 Cut Grass B5 - 10/23/2015
B6 - 10/26/2015 - Taking into account no work on the weekend.
B7 - 10/27/2015 .... etc

but if it takes longer to sweep the floor, say 6 days, i'd like the code to account for the weekend and show

A1 Sweep Floor B1 - 10/19/2015
B2 - 10/20/2015
B3 - 10/21/2015
B4 - 10/22/2015
B5 - 10/26/2015
B6 - 10/27/2015
B1 Cut Grass B7 - 10/28/2015
B8 - 10/28/2015 .... etc


Any help in making this automation would be greatly appreciated.

[protonLeah]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.


http://www.excelforum.com/excel-gene...able-date.html



Thread Closed.