Determine Fiscal Years Between 2 date ranges

[rel88]

Hello,
I'm trying to set up a formula in excel to determine which fiscal years are included in a range of 2 dates. The fiscal year runs Oct 1 - Sept 30.

If I have fiscal years as columns, is there a formula that check the dates and indicates with a 1 or 0 if the range of dates includes that fiscal year or not?

Thanks!

 

[JGordon11]

Book1
	A	B
1	Start	End
2	1/1/2015	12/16/2021
3
4	FY starting	FY In Start/End?
5	10/1/2011	0
6	10/1/2012	0
7	10/1/2013	0
8	10/1/2014	0
9	10/1/2015	1
10	10/1/2016	1
11	10/1/2017	1
12	10/1/2018	1
13	10/1/2019	1
14	10/1/2020	1
15	10/1/2021	0
Sheet2

Cell Formulas
Range	Formula
B5:B15	B5	=IF((A5>=$A$2)*(DATE(YEAR(A5)+1,9,30)<=$B$2),1,0)

 

[rel88]

Thanks for the quick response!! In your example, there should be a "1" in row B15 since the end date is after 10/1/201, and there should also be a "1" in B8 since 1/1/2015 falls in FY14 (the FY starting 10/1/2014). Any thoughts on how to account for that? Thanks!!

 

[JGordon11]

Book1
	A	B
1	Start	End
2	1/1/2015	12/16/2021
3
4	FY starting	Any part of FY In Start/End?
5	10/1/2011	0
6	10/1/2012	0
7	10/1/2013	0
8	10/1/2014	1
9	10/1/2015	1
10	10/1/2016	1
11	10/1/2017	1
12	10/1/2018	1
13	10/1/2019	1
14	10/1/2020	1
15	10/1/2021	1
16	10/1/2022	0
17	10/1/2023	0
Sheet2

Cell Formulas
Range	Formula
B5:B17	B5	=IF((A5>=$A$2)*(A5<=$B$2)+(DATE(YEAR(A5)+1,9,30)>=$A$2)*(DATE(YEAR(A5)+1,9,30)<=$B$2),1,0)

 

[rel88]

Amazing! Thank you so much!!