lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
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.
| task | start date | # of day | end date |
| task1 | 2/27/2019 | 4 | =WORKDAY(B2,C2) |
| task2 | =D2+1 | ||
| task3 | |||
| task4 | |||
| task5 | |||
| task6 | |||
| task7 | |||
| task8 |
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
