If the range in which u r searching has the date as String and not as
Date then you will #N/A. If you enter the dates as dates, this will be
resolved

Is there a way to change the cell be a date and not a date-String. My
cell contains a reference (=E1) to another worksheet.