Pivot table question

[floggingmolly]

I have a worksheet with 3 columns. Column A and B are dates, and column C is an ID#. Column A has a start date, B is end date. For example Column A1-A7 is 1/3/2022, Column B1-B7 is 1/10/2022, and so on. I need a pivot table that shows like this:
Begin Date End Date # of IDs
1/3/2021 6/3/2022 5
1/10/2021 6/10/2022 7
1/17/2021 6/17/2022 20
and so on fir each date range. I can't figure out how to get the Begin Date and end date in 2 columns beside each other in the pivot table. Any help would be appreciated.

 

[BSALV]

Map1
	A	B	C	D	E	F	G	H	I	J	K
1	start	end	ID			min	ma 01/03/22		start	number
2	ma 01/03/22	vr 06/03/22	5			max	vr 06/17/22		ma 01/03/22	1
3	ma 01/10/22	vr 06/10/22	7				166		di 01/04/22	1
4	ma 01/17/22	vr 06/17/22	20						wo 01/05/22	1
5									do 01/06/22	1
6									vr 01/07/22	1
7									za 01/08/22	1
8									zo 01/09/22	1
9									ma 01/10/22	2
10									di 01/11/22	2
Blad1

Cell Formulas
Range	Formula
I2:I167	I2	=SEQUENCE(G3,,G1)
G1	G1	=MIN(Tabel1[[start]:[end]])
G2	G2	=MAX(Tabel1[[start]:[end]])
G3	G3	=+G2-G1+1
J2:J10	J2	=SUMPRODUCT((Tabel1[start]<=I2)*(I2<=Tabel1[end]))
Dynamic array formulas.