Calculate historical FX rates based on date field

[agueiro]

So I have different sheets with amounts in different currencies for different dates and I want to fetch the USD value for that amount based on the date in the relevant columns. Can this be automated?

 

[DRSteele]

Assuming you have up-to-date Excel, you can use the Stock Data Types functionality combined with function STOCKHISTORY to retrieve historical data for currencies.

This MrExcel article might be relevant.