Extracting Data from a Range that Excludes Blanks

[taraajordan]

Hello,

I have a spreadsheet with a range of dates based on fiscal years from 10/01/2019 through 09/30/2022. I'm trying to use a formula that looks at this list of dates in a column and then extracts only the dates that occur within fiscal year 2020 which is from 10/01/2019 through 09/03/2020. I've searched everywhere today and I keep seeing the formula that starts with =IFERROR(IF(DATE RANGE),SMALL(IF(DATE RANGE), ROWS (......), ETC. I've tried several different formulas, but none have worked for what I'm trying to do. I was able to use an IF formula to pull data based on the date range listed above, but it also listed blanks for data with a zero value, and I don't want the blanks; only the data relating to this fiscal year. Please help!

 

[RasGhul]

You could use the following, IFERROR with arrays is notorious for slowing sheets down so it's better to use a count to turn the array on & off.

With this setup you can control the date period, in Option 2 formula is an example of how you can incorporate the count test if you don't want the extra Counts helper cells.

Book1
	A	B	C	D	E	F
1	Data	Event	$		Start	Counts
2	02-10-19	Event1	10		01-10-19	4
3					Finish
4	01-09-19	Event 2	45		30-09-20
5	05-10-19	Event3	50
6
7
8	20-01-20	Event6	60
9	02-02-20	Event7	100
10
11	01-10-20	Event 9	62
12
13	Option 1
14	Extract	Event	$
15	02-10-19	Event1	10
16	05-10-19	Event3	50
17	20-01-20	Event6	60
18	02-02-20	Event7	100
19
20	Option 2
21	02-10-19	Event1	10
Sheet1

Cell Formulas
Range	Formula
F2	=COUNTIFS($A$2:$A$11,">="&$E$2,$A$2:$A$11,"<="&$E$4)
A15	{=IF(ROWS(A$15:A15)>$F$2,"",INDEX(A$2:A$11,SMALL(IF($A$2:$A$11>$E$2,ROW($A$2:$A$11)-ROW($A$2)+1),ROWS(A$15:A15))))}
A21	{=IF(ROWS(A$15:A15)>COUNTIFS($A$2:$A$11,">="&$E$2,$A$2:$A$11,"<="&$E$4),"",INDEX(A$2:A$11,SMALL(IF($A$2:$A$11>$E$2,ROW($A$2:$A$11)-ROW($A$2)+1),ROWS(A$15:A15))))}
Press CTRL+SHIFT+ENTER to enter array formulas.