how to derive a column of weekdays and their corresponding date but excluding holidays

[shawnbull]

Is it possible to derive 2 columns that contains only weekdays (dates and day) but excludes public holidays?

eg if 4th July falls on a Wednesday can I derive a column automatically that lists like :-

July
2 Monday
3 Tuesday
5 Thursday
6 Friday
9 Monday

instead of

July
2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
9 Monday

Thank you

 

[sheetspread]

Excel 2010
	A	B	C	D	E
1					1/1/2016
2	7/1/2016	Friday			1/18/2016
3	7/5/2016	Tuesday			2/15/2016
4	7/6/2016	Wednesday			3/25/2016
5	7/7/2016	Thursday			5/30/2016
6	7/8/2016	Friday			7/4/2016
7	7/11/2016	Monday			9/5/2016
8	7/12/2016	Tuesday			11/24/2016
9	7/13/2016	Wednesday			11/25/2016
10	7/14/2016	Thursday			12/23/2016
11	7/15/2016	Friday			12/26/2016
12	7/18/2016	Monday
13	7/19/2016	Tuesday
14	7/20/2016	Wednesday
15	7/21/2016	Thursday
16	7/22/2016	Friday
17	7/25/2016	Monday
18	7/26/2016	Tuesday
19	7/27/2016	Wednesday
20	7/28/2016	Thursday
21	7/29/2016	Friday
22	8/1/2016	Monday
23	8/2/2016	Tuesday
24	8/3/2016	Wednesday
25	8/4/2016	Thursday
26	8/5/2016	Friday
27	8/8/2016	Monday
28	8/9/2016	Tuesday
29	8/10/2016	Wednesday
30	8/11/2016	Thursday
31	8/12/2016	Friday
32	8/15/2016	Monday
33	8/16/2016	Tuesday
34	8/17/2016	Wednesday
35	8/18/2016	Thursday
36	8/19/2016	Friday
37	8/22/2016	Monday
38	8/23/2016	Tuesday
39	8/24/2016	Wednesday
40	8/25/2016	Thursday
41	8/26/2016	Friday
42	8/29/2016	Monday
43	8/30/2016	Tuesday
44	8/31/2016	Wednesday
45	9/1/2016	Thursday
46	9/2/2016	Friday
47	9/6/2016	Tuesday
48	9/7/2016	Wednesday
49	9/8/2016	Thursday
Sheet6

Cell Formulas
Range	Formula
B2	=TEXT(WEEKDAY(A2),"DDDD")
A3	=WORKDAY(A2,1,$E$1:$E$11)

 

[shawnbull]

Thank you, such a simple solution that makes a large chunk of work suddenly much easier. Appreciate the prompt response