Problem: How to search for a date, in a list, when lookup value is a text?

Solution: Value() converts a text string that represents a number to a number

Lookup value is a text string. Formatted to the left in the cell. This is quite the contrary to column A, formatted as dates and placed to the right in the cells.

Value(text)
Converts a text string that represents a number to a number