Can you tell me what formula should i use in gsheet in getting the date between a range and displays the first date of the range. SAMPLE DATE (END DATE): 073124 then specifically the date range where this given date falls between 071124-090824 in the series of ranges. I need the 051224 to autodisplay in Column B shown below.