extend Excel formula to filter based on a period

[esmarques]

Hello, would anybody be able to help?
In the table below, how can I filter the results on cells U5, U6and U7 based on the period selected ( start date on cell U1 and end Date on Cell U2)
The column D is where the reference dates....
Any help is welcome.
Thank you

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	in	device	referrer	date	time	name	postcode	email	reason	travel	spare1	spare2	spare3	spare4		District	Month			Start Date	4/1/24
2	in	750	81.149.159.151	3/3/24	9:52:10	Mark	ol5 0dw		5	1	0	0	0	0		Tameside	Mar-24			End Date	12/31/25
3	in	750	81.149.159.151	6/4/24	9:35:57	Ciara	M4 4EE		5	2	0	0	0	0		Manchester	Jun-24
4	in	750	81.149.159.151	6/4/24	9:11:46	Freya	SK15 3LH		12	2	0	0	0	0		Tameside	Jun-24				Total
5	in	750	81.149.159.151	6/4/24	19:02:25	Jon	OL5 0QR		5	0	0	0	0	0		Tameside	Jun-24			Individuals	4
6	in	101	195.11.117.2	6/3/24	17:21:46	Jon	OL5 0QR		12	0	0	0	0	0		Tameside	Jun-24			Districts	2
7	in	961	80.229.9.166	6/3/25	11:34:31	Jon	OL5 0QR		7	0	0	0	0	0		Tameside	Jun-25			artist	3
8
9
New Data

Cell Formulas
Range	Formula
P2:P9	P2	=IF(G2<>0,IFERROR(VLOOKUP(G2,'[Vale sign in data analysis.xlsm]PostCodes1'!$A$1:$E$1040000,4,FALSE),IFERROR(VLOOKUP(G2,'[Vale sign in data analysis.xlsm]PostCodes1'!$B$1:$E$1040000,3,FALSE),IFERROR(VLOOKUP(G2,'[Vale sign in data analysis.xlsm]PostCodes2'!$A$1:$E$1040000,4,FALSE),IFERROR(VLOOKUP(G2,'[Vale sign in data analysis.xlsm]PostCodes2'!$B$1:$E$1040000,3,FALSE),"Not found")))),"")
Q2:Q9	Q2	=IF(D2<>0,TEXT(D2,"mmm-YY"),"")
U5	U5	=IFERROR(ROWS(UNIQUE(FILTER('New Data'!F2:F9998,'New Data'!$F2:$F9998<>""))),0)
U6	U6	=IFERROR(ROWS(UNIQUE(FILTER('New Data'!$P$2:$P$9998,'New Data'!$P$2:$P$9998<>""))),0)
U7	U7	=IFERROR(ROWS(UNIQUE(FILTER('New Data'!F2:'New Data'!F9998,'New Data'!I2:'New Data'!I9998=5))),0)

 

[hagia_sofia]

How about like this:

=ROWS(UNIQUE(FILTER(F2:F7,(D2:D7>=U1)*(D2:D7<=U2))))

=ROWS(UNIQUE(FILTER(P2:P7,(D2:D7>=U1)*(D2:D7<=U2))))

=ROWS(UNIQUE(FILTER(I2:I7,(D2:D7>=U1)*(D2:D7<=U2))))

 

[esmarques]

How about like this:

=ROWS(UNIQUE(FILTER(F2:F7,(D2:D7>=U1)*(D2:D7<=U2))))

=ROWS(UNIQUE(FILTER(P2:P7,(D2:D7>=U1)*(D2:D7<=U2))))

=ROWS(UNIQUE(FILTER(I2:I7,(D2:D7>=U1)*(D2:D7<=U2))))

Hello, thanks for your reply, but I would still need the other filters/counts that were there before....

 

[hagia_sofia]

=ROWS(UNIQUE(FILTER(F2:F7,(D2:D7>=U1)*(D2:D7<=U2)*(F2:F7<>""))))

=ROWS(UNIQUE(FILTER(P2:P7,(D2:D7>=U1)*(D2:D7<=U2)*(P2:P7<>""))))

=ROWS(UNIQUE(FILTER(F2:F7,(D2:D7>=U1)*(D2:D7<=U2)*(I2:I7=5))))

 

[esmarques]

=ROWS(UNIQUE(FILTER(F2:F7,(D2:D7>=U1)*(D2:D7<=U2)*(F2:F7<>""))))

=ROWS(UNIQUE(FILTER(P2:P7,(D2:D7>=U1)*(D2:D7<=U2)*(P2:P7<>""))))

=ROWS(UNIQUE(FILTER(F2:F7,(D2:D7>=U1)*(D2:D7<=U2)*(I2:I7=5))))

amazing.... thank you very much

 

[smozgur]

amazing.... thank you very much

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.