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.
<tbody>
</tbody>
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>