Calculate a conversion rate on a specific date

emmacomeau

I have a budget that has expenses in both USD and EUR.

I report expenses in USD to our finance department.

I'd like to be able to calculate the euro to usd conversion rate for the date that something is paid. Is there a formula not to pull the current conversion rate, but a conversion rate from a specific date, in this instance the paid date?

Andrée Starå

Hi Emma,

A possible workaround would be to use a third-party tool like Zapier or similar.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Or maybe a historical conversion rates table that you can reference in your calculations using an INDEX/MATCH function? But that would have to be manually built and maintained.