Earliest Date, ingnoring text #N/A

You're not reading what I am asking: from post #12: "What is the formula you originally had in I4?"

Also, is there a reason why =IFERROR(VLOOKUP(B4,'Multi-Category Schedules Co'!B:C,2,FALSE),"") would result in =IFERROR(VLOOKUP(B4,'Multi-Category Schedules Co'!B:C,2,FALSE),"")??

Is the cell formatted as Text?

Cell is formatted as date