matching dates are not been matched

column A in Sheet 1 has dates in the date format mm/dd/yyyy. column B in
Sheet 1 is pulling dates from another sheet Sheet 2 and should be matching
the corresponding dates and inputing a number from another column.

The time it works is when I manually type the date in sheet 2 and by doing
so break the link/reference of this cell to yet another file that is storing
all the data to be sorted and then graphed.

Is there a reason why the date in in the date column in sheet 2 is not able
to be recongized by sheet 1.
does date matching only workes when the date is a text or not a reference,
and if so is there a way around it.

thanks.

dario

=?Utf-8?B?ZF9jYW1wZWxvQGhvdG1haWwuY29t?=