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?