Exluding weekend from workday.

[RahulNa]

Hi Team,

I have a google sheet where my table follow like the below.

I want to make my date column automated in such a way that it excludes the weekend days.

S.No.	Date	Task	time
1	9/21/2017	a	08:00 am
2	9/21/2017	b	11:30 am
3	9/21/2017	c	02:00 pm
4	9/21/2017	d	02:00 pm
5	9/21/2017	e	02:00 pm
6	9/21/2017	f	02:00 pm
7	9/21/2017	g	02:00 pm
8	9/21/2017	h	02:00 pm
9	9/21/2017	i	02:00 pm
10	9/21/2017	j	02:00 pm
11	9/22/2017	a	08:00 am
12	9/22/2017	b	11:30 pm
13	9/22/2017	c	02:00 pm
14	9/22/2017	d	02:00 pm
15	9/22/2017	e	02:00 pm
16	9/22/2017	f	02:00 pm
17	9/22/2017	g	02:00 pm
18	9/22/2017	h	02:00 pm
19	9/22/2017	i	02:00 pm
20	9/22/2017	j	02:00 pm

<tbody>
</tbody>

 

[Scott Huish]

This is not a Google Sheets forum so I had to look it up but Google Sheets has a WORKDAY function like Excel does:

http://www.mousewhisperer.co.uk/drivebunny/calculate-using-workday-in-google-sheets/