Index/Match formula for specific date range?

[cyrous0425]

Good day guys. I have a sheet like this https://imgur.com/a/OXju6Bg. Is this possible when I entered date in cell E2&E3 I want the names in the range date that I entered with the value of 1 to appear in cell H3? Thanks

 

[Aladin Akyurek]

I had to retype everything into Excel your picture shows. Please provide next time your sample yourself in an Excel readable form.

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
2				19-Nov-18				name
3				24-Nov-18				george
4								paul
5								drake
6								john
7
8		11/19/2018	11/20/2018	11/21/2018	11/22/2018	11/23/2018	11/24/2018	11/25/2018	11/26/2018	11/27/2018	11/28/2018	11/29/2018	11/30/2018	12/1/2018	12/2/2018	12/3/2018	12/4/2018
9	george	1				1	1	1
10	paul						1	1	1	1	1	1	1	1	1	1
11	drake	1							1		1		1		1
12	john		1	1			1		1	1	1	1	1	1	1		1
13	kenneth							1		1	1	1		1		1
14	roy							1	1					1	1	1
Sheet1

In I3 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($B$9:$B$14,SMALL(IF(FREQUENCY(IF($C$8:$R$8>=$E$2,IF($C$8:$R$8<=$E$3,IF($C$9:$R$14=1,MATCH($B$9:$B$14,$B$9:$B$14,0)))),ROW($B$9:$B$14)-ROW($B$9)+1),ROW($B$9:$B$14)-ROW($B$9)+1),ROWS($1:1))),"")

 

[cyrous0425]

Good Day Sir would you mind looking to my entire sheet because I modify it. Here it is https://drive.google.com/open?id=1GoH102qo7XEY1pOD2x_Bvw9fkzPezLQ-. So basically I need to do the same. I want in my summary sheet to appear the names with in the date range. Thank you so much.

 

[Fluff]

See my rely in your other thread https://www.mrexcel.com/forum/excel...-formula-specific-date-range.html#post5179546