If date is in certain month return year range (ex. 2018-2019)

[wheellp]

I need a hero. I have a spreadsheet spread over a few years and am looking for a formula to help with the following. We have what is called a "bid season" that is from October through May. I am trying to have a value returned in column F to combine years if a date in column C is between Oct-May and if not between those months (June-Sept) to be blank . Example if the date =10/6/2018 or 4/9/2019 that the value returned would be 2018-2019 and so on for 1,100+ rows spanning from 2017 to present. See example data below. Let me know if I need to clarify anything please.

Book3
	A	B	C	D	E	F	G
1	CUSTOMER	REQUESTED BY	REQUEST DATE	Bid Season (Oct to May)	Month	Bid Season year	Example without formula
2	Customer 1	Employee 1	1/3/2017	Yes	1		2016-2017
3	Customer 2	Employee 2	2/10/2017	Yes	2		2016-2017
4	Customer 3	Employee 3	7/13/2017	No	2		(blank- not in Oct-May)
5	Customer 4	Employee 4	11/24/2017	Yes	2		2017-2018
6	Customer 5	Employee 5	1/3/2018	Yes	2		2017-2018
7	Customer 6	Employee 6	2/10/2018	Yes	2		2017-2018
8	Customer 7	Employee 7	7/13/2018	No	2		(blank- not in Oct-May)
9	Customer 8	Employee 8	11/24/2018	Yes	2		2018-2019
10	Customer 9	Employee 9	1/3/2019	Yes	2		2018-2019
11	Customer 10	Employee 10	2/10/2019	Yes	2		2018-2019
12	Customer 11	Employee 11	7/13/2019	No	2		(blank- not in Oct-May)
13	Customer 12	Employee 12	11/24/2019	Yes	2		2019-2020
14	Customer 13	Employee 13	1/3/2020	Yes	2		2019-2020
15	Customer 14	Employee 14	2/10/2020	Yes	2		2019-2020
16	Customer 15	Employee 15	7/13/2020	No	2		(blank- not in Oct-May)
17	Customer 16	Employee 16	11/24/2020	Yes	2		2020-2021
Sheet1

Cell Formulas
Range	Formula
D2:D17	D2	=IF(OR(MONTH(C2)={1,2,3,4,5,10,11,12}),"Yes","No")
E2:E17	E2	=MONTH('Profile Request Tracker Report AUTO.xlsm'!All[@[REQUEST DATE]])

 

[Tetra201]

See if the following works for you:

=IF(MONTH(EDATE(C2,-9))<9,YEAR(EDATE(C2,-9))&"-"&YEAR(EDATE(C2,3)),"")

 

[wheellp]

um that's awesome! Thank you very much!!

 

[Tetra201]

You are most welcome.