Calculate Week commencing summary based on the daily data

[Adit]

Hello,
I am trying to create a weekly summary based on the daily dispatch information. The daily dates are extended up to 52 weeks and can be changed. So, I was looking for help to create a dynamic Excel-based formula to summarize daily data into week-commencing dates.
Please see the below example for 3 weeks only (the dataset is extended up to 52 weeks) and the desired output.

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1		20/01/2025	21/01/2025	22/01/2025	23/01/2025	24/01/2025	25/01/2025	26/01/2025	27/01/2025	28/01/2025	29/01/2025	30/01/2025	31/01/2025	01/02/2025	02/02/2025	03/02/2025	04/02/2025	05/02/2025	06/02/2025	07/02/2025	08/02/2025	09/02/2025
2	BELGIUM	66	106	136	85	94	90	121	90	109	140	113	71	85	88	77	56	104	79	92	68	72
3	NETHERLANDS	82	114	161	121	114	168	197	129	167	178	142	95	98	148	120	125	140	92	112	87	93
4	POLAND	30	50	86	31	43	59	73	41	47	62	54	58	38	72	26	37	63	48	59	31	35
5
6	Output	20/01/2025	27/01/2025	03/02/2025
7	BELGIUM	698	698	546
8	NETHERLANDS	957	957	769
9	POLAND	372	372	299
Sheet1

Cell Formulas
Range	Formula
B7:B9	B7	=SUM(B2:H2)
C7:C9	C7	=SUM(I2:O2)
D7:D9	D7	=SUM(P2:V2)

 

[FormR]

Hi, here's one option you can try:

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1		20/01/2025	21/01/2025	22/01/2025	23/01/2025	24/01/2025	25/01/2025	26/01/2025	27/01/2025	28/01/2025	29/01/2025	30/01/2025	31/01/2025	01/02/2025	02/02/2025	03/02/2025	04/02/2025	05/02/2025	06/02/2025	07/02/2025	08/02/2025	09/02/2025
2	BELGIUM	65.73	105.8	135.92	84.74	93.95	90.38	121.19	90.46	109.46	140.1	113.13	70.98	85.38	88.21	76.88	55.72	103.55	78.54	92.14	67.54	71.74
3	NETHERLANDS	82.12	114.01	160.89	120.65	113.68	168.24	197.34	129.3	166.65	177.58	142.23	94.59	98.18	148.4	119.79	124.8	140.29	92.08	111.53	87.2	93.03
4	POLAND	29.7	50.25	85.72	31.08	42.94	59.39	72.88	41.21	46.65	61.97	53.54	57.89	38.28	72.41	25.6	37.44	62.66	48.4	59.03	30.89	34.79
5
6	Output	20/01/2025	27/01/2025	03/02/2025
7	BELGIUM	697.71	697.72	546.11
8	NETHERLANDS	956.93	956.93	768.72
9	POLAND	371.96	371.95	298.81
Sheet1

Cell Formulas
Range	Formula
B7:D9	B7	=SUMIFS(INDEX($B$2:$V$4,MATCH($A7,$A$2:$A$4,0),0),$B$1:$V$1,">="&B$6,$B$1:$V$1,"<"&B$6+7)

 

[Adit]

Hi, here's one option you can try:

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1		20/01/2025	21/01/2025	22/01/2025	23/01/2025	24/01/2025	25/01/2025	26/01/2025	27/01/2025	28/01/2025	29/01/2025	30/01/2025	31/01/2025	01/02/2025	02/02/2025	03/02/2025	04/02/2025	05/02/2025	06/02/2025	07/02/2025	08/02/2025	09/02/2025
2	BELGIUM	65.73	105.8	135.92	84.74	93.95	90.38	121.19	90.46	109.46	140.1	113.13	70.98	85.38	88.21	76.88	55.72	103.55	78.54	92.14	67.54	71.74
3	NETHERLANDS	82.12	114.01	160.89	120.65	113.68	168.24	197.34	129.3	166.65	177.58	142.23	94.59	98.18	148.4	119.79	124.8	140.29	92.08	111.53	87.2	93.03
4	POLAND	29.7	50.25	85.72	31.08	42.94	59.39	72.88	41.21	46.65	61.97	53.54	57.89	38.28	72.41	25.6	37.44	62.66	48.4	59.03	30.89	34.79
5
6	Output	20/01/2025	27/01/2025	03/02/2025
7	BELGIUM	697.71	697.72	546.11
8	NETHERLANDS	956.93	956.93	768.72
9	POLAND	371.96	371.95	298.81
Sheet1

Cell Formulas
Range	Formula
B7:D9	B7	=SUMIFS(INDEX($B$2:$V$4,MATCH($A7,$A$2:$A$4,0),0),$B$1:$V$1,">="&B$6,$B$1:$V$1,"<"&B$6+7)

Many Thanks