Sumifs for week of month

[FlashDota]

I want to sumifs based on weeks of the month, the results should be for the month that is on top of "First week", displayed for "First week, Second week, Third week and Fourth week". Note: Column A is in text form, while Date is mm/dd/yyyy

Number	Date	Amount		January 2024
January 2024	1/1/2024​	154​		First week
January 2024	1/2/2024​	104​		Second week
January 2024	1/3/2024​	133​		Third week
January 2024	1/4/2024​	127​		Fourth week
January 2024	1/5/2024​	102​
January 2024	1/6/2024​	103​
January 2024	1/7/2024​	134​
January 2024	1/8/2024​	176​
January 2024	1/9/2024​	101​
January 2024	1/10/2024​	158​
January 2024	1/11/2024​	141​
January 2024	1/12/2024​	134​
January 2024	1/13/2024​	180​
January 2024	1/14/2024​	148​
January 2024	1/15/2024​	174​
January 2024	1/16/2024​	181​
January 2024	1/17/2024​	103​
January 2024	1/18/2024​	102​
January 2024	1/19/2024​	170​
January 2024	1/20/2024​	170​
January 2024	1/21/2024​	138​
January 2024	1/22/2024​	145​
January 2024	1/23/2024​	112​
January 2024	1/24/2024​	179​
January 2024	1/25/2024​	151​
January 2024	1/26/2024​	167​
January 2024	1/27/2024​	151​
January 2024	1/28/2024​	167​
January 2024	1/29/2024​	121​
January 2024	1/30/2024​	156​
January 2024	1/31/2024​	110​
February 2024	2/1/2024​	166​
February 2024	2/2/2024​	138​
February 2024	2/3/2024​	132​
February 2024	2/4/2024​	171​
February 2024	2/5/2024​	147​
February 2024	2/6/2024​	106​
February 2024	2/7/2024​	186​
February 2024	2/8/2024​	161​
February 2024	2/9/2024​	147​
February 2024	2/10/2024​	141​
February 2024	2/11/2024​	177​
February 2024	2/12/2024​	148​
February 2024	2/13/2024​	138​
February 2024	2/14/2024​	122​
February 2024	2/15/2024​	165​
February 2024	2/16/2024​	125​
February 2024	2/17/2024​	165​
February 2024	2/18/2024​	149​
February 2024	2/19/2024​	117​
February 2024	2/20/2024​	129​
February 2024	2/21/2024​	158​
February 2024	2/22/2024​	190​
February 2024	2/23/2024​	167​
February 2024	2/24/2024​	126​
February 2024	2/25/2024​	165​
February 2024	2/26/2024​	129​
February 2024	2/27/2024​	126​
February 2024	2/28/2024​	191​
February 2024	2/29/2024​	108​

 

[awoohaw]

How do you determine what a week in the month is? is week 1 always the first 7 days? If so what about the last 1,2,or 3 days?
or do you have the week starting on a specific day?

 

[FlashDota]

How do you determine what a week in the month is? is week 1 always the first 7 days? If so what about the last 1,2,or 3 days?
or do you have the week starting on a specific day?

For this example I would take days 1-7 week 1, 8-14 week 2 and so on. Looks like I have to add a Fifth week as well

 

[awoohaw]

For this example I would take days 1-7 week 1, 8-14 week 2 and so on. Looks like I have to add a Fifth week as well

so the fifth week will only be 1, 2, or 3 days?

 

[awoohaw]

Well, this gets your January Data. I'm unsure how you want February displayed. The worksheet would need to be updated for that.

Book1
	A	B	C	D	E	F	G
1	Number	Date	Amount		January 2024
2	January 2024	2024-01-01	154		First week		857
3	January 2024	2024-01-02	104		Second week		1038
4	January 2024	2024-01-03	133		Third week		1038
5	January 2024	2024-01-04	127		Fourth week		1072
6	January 2024	2024-01-05	102		Fifth Week		387
7	January 2024	2024-01-06	103
8	January 2024	2024-01-07	134
9	January 2024	2024-01-08	176
10	January 2024	2024-01-09	101
11	January 2024	2024-01-10	158
12	January 2024	2024-01-11	141
13	January 2024	2024-01-12	134
14	January 2024	2024-01-13	180
15	January 2024	2024-01-14	148
16	January 2024	2024-01-15	174
17	January 2024	2024-01-16	181
18	January 2024	2024-01-17	103
19	January 2024	2024-01-18	102
20	January 2024	2024-01-19	170
21	January 2024	2024-01-20	170
22	January 2024	2024-01-21	138
23	January 2024	2024-01-22	145
24	January 2024	2024-01-23	112
25	January 2024	2024-01-24	179
26	January 2024	2024-01-25	151
27	January 2024	2024-01-26	167
28	January 2024	2024-01-27	151
29	January 2024	2024-01-28	167
30	January 2024	2024-01-29	121
31	January 2024	2024-01-30	156
32	January 2024	2024-01-31	110
33	February 2024	2024-02-01	166
34	February 2024	2024-02-02	138
35	February 2024	2024-02-03	132
36	February 2024	2024-02-04	171
37	February 2024	2024-02-05	147
38	February 2024	2024-02-06	106
39	February 2024	2024-02-07	186
40	February 2024	2024-02-08	161
41	February 2024	2024-02-09	147
42	February 2024	2024-02-10	141
43	February 2024	2024-02-11	177
44	February 2024	2024-02-12	148
45	February 2024	2024-02-13	138
46	February 2024	2024-02-14	122
47	February 2024	2024-02-15	165
48	February 2024	2024-02-16	125
49	February 2024	2024-02-17	165
50	February 2024	2024-02-18	149
51	February 2024	2024-02-19	117
52	February 2024	2024-02-20	129
53	February 2024	2024-02-21	158
54	February 2024	2024-02-22	190
55	February 2024	2024-02-23	167
56	February 2024	2024-02-24	126
57	February 2024	2024-02-25	165
58	February 2024	2024-02-26	129
59	February 2024	2024-02-27	126
60	February 2024	2024-02-28	191
61	February 2024	2024-02-29	108
Sheet1

Cell Formulas
Range	Formula
G2:G6	G2	=SUMPRODUCT(($C$2:$C$61)*((INT((DAY($B$2:$B$61)-1)/7)+1)=(MOD((ROW()-2),7)+1))*(MONTH($B$2:$B$61)=MONTH(0+$E$1)))