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.
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.