Hello all, nice to have such a great community to post to when I come across another question - so here it is...

In the left column (A) I have sequence numbers.
In the center column (B) I have the task name.
In the right column (C) I have the scheduled date.

All tasks on the same sequence number need to be scheduled for the same day. For example: I will fill in the date manually for "Break ground" (base line date) then, under Seq. 2 below "drop dirt" and "drop forms" would need to be scheduled on the same day based on the sequence number. Then, "Set forms" and Drop float" for the next day (excluding Sundays only) and so on and so on...

I am currently using the formula: =IF(WEEKDAY(C2+1,2)=7,C2+2,C2+1)

As you can see below my formula is not working because it is not accounting for the sequence number but only the previous date.

Current PROBLEM - what it currently looks like...

Seq. Task Scheduled
1 Break ground *****Friday, 9/15/17*****
2 Drop dirt Saturday, 9/16/17
2 Drop forms Monday, 9/18/17
3 Set forms Tuesday, 9/19/17
3 Drop float Wednesday, 9/20/17
4 Set float Thursday, 9/21/17
5 Concrete Friday, 9/22/17


What it should look like...

Seq. Task Scheduled
1 Break ground *****Friday, 9/15/17*****
2 Drop dirt Saturday, 9/16/17
2 Drop forms Monday, 9/16/17
3 Set forms Tuesday, 9/17/17
3 Drop float Wednesday, 9/17/17
4 Set float Thursday, 9/18/17
5 Concrete Friday, 9/19/17


Any help is greatly APPRECIATED!!!!!