Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The EXCHANGE function is used to obtain the exchange rate between two currencies on a specific date. This can be useful for financial calculations, budgeting, and international transactions.
Syntax
EXCHANGE(from_currency, to_currency, date)
The EXCHANGE function syntax has the following arguments:
- from_currency Required. The currency code of the currency you want to convert from (e.g., "USD").
- to_currency Required. The currency code of the currency you want to convert to (e.g., "EUR").
- date Required. The date for which you want to obtain the exchange rate. Dates should be entered either by using the "YYYY-MM-DD" format or by using the DATE function, or as results of other formulas or functions.
Example
| Formula | Description | Result |
| =EXCHANGE("USD", "EUR", 2022-01-01) | Gets the exchange rate from USD to EUR on January 1st, 2022. | 0.88 |
| =EXCHANGE("GBP", "USD", 2021-12-31) | Gets the exchange rate from GBP to USD on December 31st, 2021. | 1.35 |
| =EXCHANGE("JPY", "CAD", DATE(2022, 2, 15)) | Gets the exchange rate from JPY to CAD on February 15th, 2022. | 0.011 |
Errors
For a full list of formula errors, please read Formula errors.