Date and Countif Week Formula

[searchingforhelp]

Hi,

Need help in expanding the formulas and have them automatically populate when dragging column A downward in the Weekly Performance tab (second image). In the Weekly Performance tab, the dates in column A and B are pulled from the Data tab (first image) column A and B. When dragging the Weekly Performance column A downward, only column C and D populate. Is there a formula or set of formulas when dragging column column A downward, to have B through H populate with what is in the Data tab?

Lastly is there a way I can compensate for holidays that land on a Monday? If there is a holiday on Monday, have the date formula start on the Tuesday, end on Friday, and the following week, start on a Monday again.

Thank you in advance for your help.

Mr Excel.xlsx
	A	B	C
1	# of fruits delivered (Beginning of the Week)	# of fruits sold (Week Ending)	fruits
2		None sold
3	1/11/2021	1/15/2021	Oranges
4	1/11/2021	1/15/2021	Oranges
5	1/11/2021	1/15/2021	Grapes
6	1/11/2021	1/15/2021	Apples
7	1/19/2021	1/22/2021	Apples
8	1/19/2021	None sold
9	1/19/2021	None sold
10	1/25/2021	1/29/2021	Grapes
11	2/1/2021	2/5/2021	Apples
12	2/1/2021	2/5/2021	Oranges
13	2/8/2021	2/12/2021	Apples
14	2/16/2021	2/19/2021	Apples
15	2/16/2021	2/19/2021	Grapes
16	2/16/2021	None sold
17	2/16/2021	2/19/2021	Apples
18	2/16/2021	2/19/2021	Oranges
19	2/16/2021	2/19/2021	Grapes
Data

Mr Excel.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Beginning of Week (Mondays)	Week Ending (Fridays)	# of fruits delivered (Beginning of the Week)	# of fruits sold (Week Ending)	Sold Completion Rate	Apples	Oranges	Grapes	Year	Day to Find
2	Monday, January 4, 2021	Friday, January 8, 2021	0	0	0%	0	0	0	2021	5
3	Monday, January 11, 2021	Friday, January 15, 2021	4	4	100%	4	4	4
4	Tuesday, January 19, 2021	Friday, January 22, 2021	3	1	33%	1	1	1
5	Monday, January 25, 2021	Friday, January 29, 2021	1	1	100%	1	1	1
6	Monday, February 1, 2021	Friday, February 5, 2021	2	2	100%	2	2	2
7	Monday, February 8, 2021	Friday, February 12, 2021	1	1	100%	1	1	1
8	Tuesday, February 16, 2021	Friday, February 19, 2021	6	5	83%	5	5	5
Weekly performance

Cell Formulas
Range	Formula
A2	A2	=DATE(I2,1,4)-WEEKDAY(DATE(I2,1,4),3)
B2	B2	=DATE(I2,1,4)-WEEKDAY(DATE(I2,1,4),2)+J2
C2:C8	C2	=COUNTIF(Data!A:A,[@[Beginning of Week (Mondays)]])
D2:D8	D2	=COUNTIF(Data!B:B,[@[Week Ending (Fridays)]])
F2:F8	F2	=COUNTIF(Data!B:B,[@[Week Ending (Fridays)]])
G2:G8	G2	=COUNTIF(Data!B:B,[@[Week Ending (Fridays)]])
H2:H8	H2	=COUNTIF(Data!B:B,[@[Week Ending (Fridays)]])
A3:B3,B4:B5,A6:B7,B8	A3	=A2+7
E3:E8	E3	=D3/C3
A4,A8	A4	=A3+8
A5	A5	=A4+6

Named Ranges
Name	Refers To	Cells
Data!_FilterDatabase	=Data!$A$1:$B$19	C2:C8
list	=Data!$A$1:$A$19	C2:C8
list1	=Data!$A:$B	C2:C8