Hello, I am trying to extract historic temperature data between two user defined dates. This code

=TEXT(MAX(IF(Day_Weather>=Entry_Date, IF(Day_Weather<=Exit_Date, Temp_RecH), "")), "0") & " ᵒF"

Works just fine if the years match.

Variable Definitions:
Day_Weather = 365 date column range from 2014.Jan.01 - 2014.Dec.31
Entry_Date = User defined date in the format yyyy.mmm.dd
Exit_Date = User defined date in the format yyyy.mmm.dd
Temp_RecH = Record high temperature value associated with the 365 date range

If the user defined entry date and exit date are in the year 2014, the code above works just fine. However, if the dates are outside of 2014, the cell returns a #DIV/0!.

I attempted to put a TEXT(Day_Weather, mmdd) >=TEXT(Entry_Date, mmdd) but the Day_Weather range doesn't appreciate it.

Any suggestions?