Scheduling visual with start dates & durations to exclude weekends.

[FrogFace]

I have this simple spreadsheet which a14 to a47 is a list of tasks. $B$14 is the task start date, C14 is the duration of the task, and e12:ab12 are dates from Monday 11/13 to Saturday 12/9. If the task start date and duration is >= e12:ab12, then return "X" in e14:ab47. I want to show an "X" as a visual to the task's start date and duration in range e14:ab47. We don't work weekends, so these days should not have an "X" and not be counted in the duration of the task. any assistance would be appreciated. 

Activity

Est.

Act.

Responsible

Description

Start

Duration

Start

Month:

Month:

Month:

Party

13

14

15

16

17

18

20

21

22

23

24

25

27

28

29

30

1

2

4

5

6

7

8

9

M

T

W

T

F

S

M

T

W

T

F

S

M

T

W

T

F

S

M

T

W

T

F

S

Exterior Tracks

11/13

7

13-Nov

X

X

X

X

X

X

Carpenters

[#2]

I would like to add, e12:ab47 should auto populate "X" after entering the estimated start date and duration.
Thanks

[#3]

@FrogFace 

See the attached demo workbook.

[#4]

looks good thank you for your help. I would like to take out the "S" indicating Saturdays but this format is from my office and I don't want to change it. Is there a way to keep Saturdays visualized in the chart ? that was my main problem.

Thanks

[#5]

Disregard previous message. All good thank you Hans Vogelaar for your help.