How to find the number of occurrence that happen on different days of the week within a month?

[GcMT]

Hi, is there any way i can find the number of occurrence that happen on different days of the week within a month of the date range?

Thanks in advance

how to find occurance.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE
2	Different start and end date		Frequency on Week-day. "0" = no occurance							Number of weekday in a month (based on date range column A and B)							Total number of Occurance
3	Start date	End Date	Mon	Tue	Wed	Thu	Fri	Sat	Sun	mon	tue	wed	thu	fri	sat	sun	1	2	3	4	5	6	7
4	5/1/18	5/31/18	1	0	1	1	1	1	1	4	5	5	5	4	4	4	0	1	1	0	1	1	0
5	5/1/18	5/31/18	1	1	1	1	1	1	1	4	5	5	5	4	4	4	0	0	0	0	0	1	0
6	5/1/18	5/31/18	1	0	1	0	1	0	0	4	5	5	5	4	4	4	0	0	0	0	0	1	0
7	5/1/18	5/31/18	0	1	0	0	0	0	0	4	5	5	5	4	4	4	1	0	0	1	0	0	2
8	5/1/18	5/31/18	1	1	1	1	1	1	1	4	5	5	5	4	4	4	2	2	2	2	2	0	2
9	5/11/18	5/25/18	0	0	1	0	0	0	0	2	2	2	2	3	2	2	0	0	3	0	0	0	0
10	5/1/18	5/29/18	0	0	0	0	1	0	1	4	5	4	4	4	4	4	3	0	0	0	0	0	4
11	5/1/18	5/31/18	0	1	0	0	0	0	0	4	5	5	5	4	4	4	0	0	4	0	0	0	0
12	5/1/18	5/31/18	1	0	1	0	1	0	1	4	5	5	5	4	4	4	0	0	0	4	0	0	0
13	5/13/18	5/31/18	1	0	1	1	1	1	1	3	3	3	3	2	2	3	0	0	0	0	4	4	0
14	5/1/18	5/31/18	1	1	1	1	1	0	1	4	5	5	5	4	4	4	0	0	0	0	4	0	5
15	5/1/18	5/31/18	0	1	0	0	0	1	0	4	5	5	5	4	4	4	0	0	0	0	0	0	5
16	5/1/18	5/31/18	0	0	0	0	0	1	0	4	5	5	5	4	4	4	0	0	0	0	0	0	5
17	5/4/18	5/25/18	0	0	1	0	0	0	0	3	3	3	3	4	3	3	0	0	0	0	0	0	5
18	5/1/18	5/26/18	0	0	0	1	0	0	0	3	4	4	4	4	4	3	0	0	0	0	0	0	5
19	5/1/18	5/31/18	1	0	1	0	1	0	1	4	5	5	5	4	4	4	0	0	0	0	4	0	5
20	5/1/18	5/29/18	0	0	0	0	0	0	1	4	5	4	4	4	4	4	5	0	0	0	0	0	0
21	5/1/18	5/31/18	0	1	0	0	0	1	0	4	5	5	5	4	4	4	5	0	4	4	4	4	5
22	5/1/18	5/31/18	0	1	0	1	0	1	0	4	5	5	5	4	4	4	5	5	4	4	4	4	5
23	5/1/18	5/13/18	0	0	0	1	0	0	0	1	2	2	2	2	2	2	5	0	4	0	4	0	0
24	5/1/18	5/31/18	0	1	0	1	0	0	1	4	5	5	5	4	4	4	0	5	0	0	0	0	0
25	5/4/18	5/31/18	0	0	1	0	1	0	0	4	4	4	4	4	4	4	5	5	4	4	4	4	5
26	5/1/18	5/31/18	1	1	0	1	0	1	1	4	5	5	5	4	4	4	0	5	0	0	0	0	0
27	5/1/18	5/31/18	1	1	1	1	0	0	0	4	5	5	5	4	4	4	5	0	4	0	4	0	5
28
29
30
31
32	Q: To find the number of occurrence that happen on different days of the week within a month?
33	5/1/18	5/2/18	5/3/18	5/4/18	5/5/18	5/6/18	5/7/18	5/8/18	5/9/18	5/10/18	5/11/18	5/12/18	5/13/18	5/14/18	5/15/18	5/16/18	5/17/18	5/18/18	5/19/18	5/20/18	5/21/18	5/22/18	5/23/18	5/24/18	5/25/18	5/26/18	5/27/18	5/28/18	5/29/18	5/30/18	5/31/18
34	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday
35
Sheet1

Cell Formulas
Range	Formula
J4:J27	J4	=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A4&":"&B4)))=2))
K4:K27	K4	=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A4&":"&B4)))=3))
L4:L27	L4	=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A4&":"&B4)))=4))
M4:M27	M4	=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A4&":"&B4)))=5))
N4:N27	N4	=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A4&":"&B4)))=6))
O4:O27	O4	=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A4&":"&B4)))=7))
P4:P27	P4	=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A4&":"&B4)))=1))
Q4:Q27	Q4	='broadsheet test.xlsx'!Table3_2[@D1]*'broadsheet test.xlsx'!Table3_2[@mon]
R4:R27	R4	='broadsheet test.xlsx'!Table3_2[@D2]*'broadsheet test.xlsx'!Table3_2[@tue]
S4:S27	S4	='broadsheet test.xlsx'!Table3_2[@D3]*'broadsheet test.xlsx'!Table3_2[@wed]
T4:T27	T4	='broadsheet test.xlsx'!Table3_2[@D4]*'broadsheet test.xlsx'!Table3_2[@thu]
U4:U27	U4	='broadsheet test.xlsx'!Table3_2[@D5]*'broadsheet test.xlsx'!Table3_2[@fri]
V4:V27	V4	='broadsheet test.xlsx'!Table3_2[@D6]*'broadsheet test.xlsx'!Table3_2[@sat]
W4:W27	W4	='broadsheet test.xlsx'!Table3_2[@D7]*'broadsheet test.xlsx'!Table3_2[@sun]