I need help finding the past date furthest from TODAY(), that is not 01-01-00, or the closest future date to TODAY(). It needs to be in one formula

I have three columns of dates. Each row corresponds to one item. I want to find the closest future date to today. So I used this =MIN(IF(G23:I23>$E$1,G23:I23)). However, for two items, the dates are all less than TODAY(). For that I would like to find the furthest past date from TODAY() that is not 01-01-00. I would like a formula that I could drag down for all items, despite having future of past dates. I need this because my dates correspond to data from a web query, so the dates may change from past to future depending on the dates on the website. I tried using the formula below (I know I used MAX because I didn't know how to exclude 01-01-00), but it gives a #VALUE error sometimes, and sometimes it doesn't.

IF(MIN(IF(G27:I27>$E$1,G27:I27))=TRUE,MIN(IF(G27:I27>$E$1,G27:I27)),(DATE(YEAR(MAX(IF(G27:I27

If anyone could help me figure this out, I would greatly appreciate it. I have tried reading about arrays but it hasn't gotten me anywhere so far.

The first picture shows the values when the first formula is used for all rows. The second picture shows the value error when only that row uses the latter formula. Results using the first formula Results using the second formula only for that row

The data 19-06-18 19-06-16 19-06-20 26-09-17 26-09-17 26-09-19 01-03-21 01-12-19 31-03-18 01-03-21 01-12-19 31-03-18 01-03-16 01-03-16 00-01-00 24-11-19 24-11-17 25-11-16 21-10-19 21-10-17 22-10-16 01-03-16 01-03-16 00-01-00 14-05-18 14-05-18 14-05-20 07-05-18 07-05-18 07-05-20