I've had difficulty interpreting what you mean by count. It wasn't clear to be whether you mean include or exclude.
If you mean when the number of days is 5 or less, weekend days aren't workdays, but for higher values weekend days would be included as workdays, and in all cases holidays aren't workdays, then I believe your D8 formula could be
which could be filled down into D9:D15.
For me that produces the following results.
|
C |
D |
E |
F |
G |
7 |
|
|
|
Friday |
11/06/2020 |
8 |
2 |
Tuesday |
11/10/2020 |
9 |
5 |
Monday |
11/16/2020 |
10 |
10 |
Tuesday |
11/17/2020 |
11 |
12 |
Thursday |
11/19/2020 |
12 |
20 |
Monday |
11/30/2020 |
13 |
30 |
Wednesday |
12/09/2020 |
14 |
30 |
Wednesday |
12/09/2020 |
15 |
30 |
Wednesday |
12/09/2020 |
By row,
8) skip Sa Su, so Mo Tu is 2 workdays later.
9) skip Sa Su, We 11/11/2020 from E28, Sa Su, so Mo Tu Th Fr Mo is 5 workdays later.
10) skip only We 11/11/2020 from E28, so Sa Su Mo Tu Th Fr Sa Su Mo Tu is 10 workdays later.
11) no holidays between 10 and 12 workdays after 11/06/2020, so (continuing 10) We Th 2 days after result from (10), so 12 workdays later.
12) skip We 11/11/2020 from E28 and Th/Fr 11/26-27/2020 from E29:E30, so Sa Su Mo Tu Th Fr Sa Su Mo Tu We Th Fr Sa Su Mo Tu We Sa Su Mo is the next non-holiday weekday from 20 days after 11/06/2020.
13-15) skip We 11/11/2020 from E28 and Th/Fr 11/26-27/2020 from E29:E30, so Sa Su Mo Tu Th Fr Sa Su Mo Tu We Th Fr Sa Su Mo Tu We Sa Su Mo Tu We Th Fr Sa Su Mo Tu We is 30 workdays later.
Bookmarks