next date but not equal to saturday or sunday

[lezawang]

Hi
I have table like below. The start date of Task2 is the End date of task1 +1


So B3 = D2 +1

But I want to avoid the date to be Saturday or sunday! So how can I do that so the start date of task2 wont be sat or sunday. Thank you so much.

[TABLE="class: grid, width: 558"]
<colgroup><col span="3"><col></colgroup><tbody>[TR]
[TD]task[/TD]
[TD]start date[/TD]
[TD]# of day[/TD]
[TD]end date[/TD]
[/TR]
[TR]
[TD]task1[/TD]
[TD]2/27/2019[/TD]
[TD]4[/TD]
[TD]=WORKDAY(B2,C2)[/TD]
[/TR]
[TR]
[TD]task2[/TD]
[TD]=D2+1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]task3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]task4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]task5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]task6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]task7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]task8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Just use workday again
=WORKDAY(D2,1)

 

[lezawang]

Thank you very much. never crossed my mind. thanks again

 

[Fluff]

You're welcome & thanks for the feedback