Multiply columns that match in 2 tables

[nando88]

I have generated an excel sheet in google sheets, that gets the history of currency rate changes from some coins to USD. What I want to do is compare the date of the column in google sheets with a dummy table with dates and if they match, then multiply the value from the rates column to the data in the second column in the dummy table.

This is the link to the table I have created in google drive:
https://docs.google.com/spreadsheets/d/158i0CA8PAGcOEkE-5donkI2luWQVCtJrn6mR6Blcfws/pubhtml

Please help me fix this, because I am receiving an error: "Can't parse date value", when trying to merge the 2 tables, using date columns as columns to match.

 

[Matt Allington]

Are you using Power Query or something? The date columns look like they have a time stamp. Convert them to date only first and see if that fixes it