Fetching Data for Different Dates
The date parameter in the formula allows you to convert currencies using both today's rates and historical exchange rates.
You can provide the date in two ways:
Referencing a Cell
If you're referencing a date from another cell, the format can be any date format supported by Google Sheets.
This will correctly use the date value from that cell, regardless of how it's formatted (e.g., 5/10/2023, 10-May-2023, or 2023-05-10), as long as it's a valid Google Sheets date.
Refer to Google's date formatting guide here.
Make sure the referenced cell contains a proper date, not a text string. If Sheets doesn't recognise it as a date, the conversion may fail.
Manually Entering a Date
If you're entering the date directly into the formula, it must follow the strict YYYY-MM-DD format.
Example: =CURRENCYCONVERT("EUR", "JPY", 50, "2023-05-10")
Incorrect formats (like "10/05/2023" or "May 10, 2023") will result in errors when entered as strings.