If a date is between 2 dates annually

[wheellp]

I am looking for a formula to determine if a date in column D is between the first day of October through last day of May from 2016-2021. I am looking to do this over several different years (Oct 2016-May 2017, Oct 2017- May 2018, Oct 2018- May 2019, etc.). I have a master spreadsheet with data from every year since 2016 that I am trying to add this to for reporting. Help please?

 

[wheellp]

Try using the XL2BB option to post a sample of your data, posting a picture means we have to re-create your data manually.

Include in your sample the expected results.

see below. I highlighted the columns to focus on. I showed what the answer should be in the bid season column, which is where I am trying to put the results. I did your formula as well to show there were several errors that would have been wrong, those are red. I also added the range I am looking for (in the months Oct, Nov, Dec, Jan, Feb, Mar, Apr, or May the result would be "yes" in column O (bid season). If the date falls within the months of Jun, Jul, Aug, or September the result would be "no" in column O (bid season).)

CUSTOMER	REQUEST TYPE	REQUEST DATE	DUE DATE	Bid Season? (Oct to May)	Formula not working	Date Range start	Date Range end
customer1	RFI	1/3/2017	2/22/2017	Yes	No
customer2	RFI	6/9/2017	6/20/2017	No	Yes
customer3	RFI	2/12/2018	2/12/2018	Yes	No	10/1/2016	5/31/2017	year 1
customer4	RFI	2/12/2018	2/12/2018	Yes	Yes	10/1/2017	5/31/2018	year 2
customer5	RFI	2/12/2018	2/13/2018	Yes	Yes	10/1/2018	5/31/2019	year 3
customer6	RFI	2/12/2018	2/13/2018	Yes	Yes	10/1/2019	5/31/2020	year 4
customer7	RFI	2/12/2018	2/14/2018	Yes	Yes	10/1/2020	5/31/2021	year 5
customer8	RFI	2/12/2018	2/16/2018	Yes	Yes	10/1/2021	5/31/2022	year 6
customer9	RFI	2/12/2018	2/16/2018	Yes	Yes	10/1/2022	5/31/2023	year 7
customer10	RFI	2/12/2018	2/19/2018	Yes	Yes	10/1/2023	5/31/2024	year 8
customer11	RFI	9/9/2018	9/9/2018	No	Yes
customer12	RFI	5/31/2019	6/5/2019	Yes	No
customer13	RFI	6/10/2019	6/10/2019	No	No
customer14	RFI	6/10/2019	6/10/2019	No	No
customer15	RFI	6/10/2019	6/12/2019	No	No
customer16	RFI	8/1/2019	8/2/2019	No	No
customer17	RFI	8/1/2019	8/2/2019	No	No
customer18	Vendor Setup/ ACH	8/2/2019	8/2/2019	No	No
customer19	RFI	8/2/2019	8/2/2019	No	No
customer20	RFI	8/2/2019	8/5/2019	No	No
customer21	RFI	8/7/2019	8/7/2019	No	No
customer22	RFI	8/7/2019	8/7/2019	No	No
customer23	RFI	8/7/2019	8/7/2019	No	No
customer24	Safety/ Security	8/7/2019	8/8/2019	No	No
customer25	RFI	8/7/2019	8/7/2019	No	No
customer26	RFI	8/8/2019	8/9/2019	No	No
customer27	Vendor Setup/ ACH	8/9/2019	8/9/2019	No	No
customer28	RFI	8/9/2019	8/12/2019	No	No
customer29	RFI	8/9/2019	8/14/2019	No	No
customer30	RFI	8/12/2019	8/16/2019	No	No
customer31	RFI	8/13/2019	8/13/2019	No	No
customer32	RFI	8/13/2019	8/13/2019	No	No
customer33	Diversity Reporting	8/13/2019	8/13/2019	No	No
customer34	RFI	8/14/2019	8/14/2019	No	No
customer35	Vendor Setup/ ACH	8/14/2019	8/15/2019	No	No
customer36	Online RFI	8/14/2019	8/16/2019	No	No
customer37	Vendor Setup/ ACH	8/16/2019	8/16/2019	No	No
customer38	RFI	8/16/2019	8/21/2019	No	No
customer39	Vendor Setup/ ACH	8/20/2019	8/20/2019	No	No
customer40	RFI	8/20/2019	8/20/2019	No	No
customer41	Vendor Setup/ ACH	8/20/2019	8/20/2019	No	No
customer42	RFI	8/20/2019	8/21/2019	No	No
customer43	RFI	8/20/2019	8/21/2019	No	No
customer44	Online RFI	8/20/2019	8/22/2019	No	No
customer45	RFI	8/22/2019	8/22/2019	No	No
customer46	Safety/ Security	8/22/2019	8/28/2019	No	No
customer47	Online RFI	8/26/2019	8/26/2019	No	No
customer48	RFI	8/27/2019	8/27/2019	No	No
customer49	RFI	8/27/2019	8/27/2019	No	No
customer50	RFI	8/27/2019	8/28/2019	No	No
customer51	RFI	8/29/2019	8/29/2019	No	No
customer52	RFI	10/10/2019	10/22/2019	Yes	No
customer53	RFI	10/10/2019	10/17/2019	Yes	Yes
customer54	RFI	10/18/2019	11/4/2019	Yes	Yes
customer55	Vendor Setup/ ACH	12/9/2019	12/9/2019	Yes	Yes
customer56	RFI	12/9/2019	12/9/2019	Yes	Yes
customer57	RFI	12/9/2019	12/19/2019	Yes	Yes
customer58	Vendor Setup/ ACH	12/9/2019	12/10/2019	Yes	Yes
customer59	RFI	12/9/2019	12/10/2019	Yes	Yes
customer60	RFI	12/9/2019	12/23/2019	Yes	Yes
customer61	Miscellaneous	12/10/2019	12/10/2019	Yes	Yes
customer62	Vendor Setup/ ACH	12/10/2019	12/11/2019	Yes	Yes
customer63	RFI	12/10/2019	12/11/2019	Yes	Yes
customer64	Online RFI	12/10/2019	12/13/2019	Yes	Yes
customer65	Vendor Setup/ ACH	3/18/2020	3/18/2020	Yes	Yes
customer66	Vendor Setup/ ACH	3/18/2020	3/19/2020	Yes	Yes
customer67	Vendor Setup/ ACH	3/18/2020	3/19/2020	Yes	Yes
customer68	RFI	3/18/2020	5/31/2020	Yes	Yes
customer69	RFI	6/3/2020	6/5/2020	No	Yes
customer70	RFI	6/3/2020	6/12/2020	No	No

 

[gaz_chops]

Try

=IF(OR(MONTH(C1)={1,2,3,4,5,10,11,12}),"Yes","No")

 

[wheellp]

Try

=IF(OR(MONTH(C1)={1,2,3,4,5,10,11,12}),"Yes","No")

That worked! Thanks for your help!

 

[gaz_chops]

You're welcome, thanks for the feedback.