Call Log Sorting Macro

[Sophiemakescakes]

I have a call log to analyze. It lists names and their phone number, dial attempts, dial date/time, and the results of the dial ( 1. no answer, 2. Spoke with a person, or 3. left a message).

I need to calculate the number of call/dial attempts that occur on an account, per day, but I only need to calculate those that occur after talking with a person or if a message was left. If all of the calls to a person/number go unanswered all day, they wouldn't be counted or analyzed

I also need to that same calculation, but over the period of 7 days. If/when a person was spoken to or a message was left , the number of dial attempts that occurred within the seven days following the call/message.

Any help would be be greatly appreciated.
Ive been programming a custom analysis program for over 2 weeks and my brain is just absolutely fried trying to figure out this past puzzle.

 

[Sophiemakescakes]

Tried uploading a mini sheet, but I cannot install stuff on this PC. And the pic I was attempting to upload was continually too big, and it doesn't give a file size limit and I gave up after the 4th go.

 

[BSALV]

good old pivottable with a slicer ?

Map1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	name	phonenumber	dial attempts	dial date time	result	week			result	(Meerdere items)
2	bsalv1	0123/456789	2	1/02/2022 7:49	1	6
3	bsalv2	0123/456790	2	2/02/2022 7:49	2	6						Waarden
4	bsalv3	0123/456791	2	3/02/2022 7:49	3	6			week	dial date time	name	Aantal van name	Som van dial attempts
5	bsalv4	0123/456792	2	4/02/2022 7:49	1	6			6	2/feb	bsalv2	1	2
6	bsalv5	0123/456793	2	5/02/2022 7:49	1	6				Totaal 2/feb		1	2
7	bsalv6	0123/456794		6/02/2022 7:49	3	7
8	bsalv7	0123/456795		7/02/2022 7:49	3	7				3/feb	bsalv3	1	2
9	bsalv8	0123/456796		8/02/2022 7:49	3	7				Totaal 3/feb		1	2
10	bsalv9	0123/456797		9/02/2022 7:49	3	7
11	bsalv10	0123/456798		10/02/2022 7:49	3	7			Totaal 6			2	4
12	bsalv11	0123/456799		11/02/2022 7:49	3	7			7	6/feb	bsalv6	1
13	bsalv12	0123/456800		12/02/2022 7:49	3	7				Totaal 6/feb		1
14
15										7/feb	bsalv7	1
16										Totaal 7/feb		1
17
18										8/feb	bsalv8	1
19										Totaal 8/feb		1
20
21										9/feb	bsalv9	1
22										Totaal 9/feb		1
23
24										10/feb	bsalv10	1
25										Totaal 10/feb		1
26
27										11/feb	bsalv11	1
28										Totaal 11/feb		1
29
30										12/feb	bsalv12	1
31										Totaal 12/feb		1
32
33									Totaal 7			7
34									Eindtotaal			9	4
35
36
Blad2

Cell Formulas
Range	Formula
F2:F13	F2	=WEEKNUM([@[dial date time]])