Vlookup Different date formats

Hi,
I have 2 different excel workbooks and trying to use Vlookup formula.I wish to extract the information when the dates match.However, I'm getting error (NA)-The reason I suspect is that the dates are in different format in both the sheets. I cannot change format in the first excel(attached-Excel1) because it comes from running a program. How can I change the format in (attached- Excel2)-to fix this error please? Ive used Text to Columns method but its not helping. Would request someone to kindly help me fix this!
Thanks.

When using text function as in your formula- I'm getting error. It gives error Attachment 696767 unfortunately.So the entire formula doesn't work!

Originally Posted by TMS

You probably need to change the commas ( , ) to semi-colons ( ; ) for your Regional Settings.

Tried that as well. But that's not the reason perhaps. Excel is identifying only first 5 characters. Len(A1) gives 5 and it picks 5 characters to dd.mm. You can also try the excel file...

Originally Posted by TMS

I DID try the excel files. That's why I KNOW the formula works.

Are the samples you posted based on the real files?

Thanks for helping. Can you share the excel with the formula where it works please- That would really help ? The excel which I attached is a sample based on real files.