Is there a way to add exchange rates next to specific dates in an excel worksheet?

Basically, same as the title

I prepare year end accounts and sometimes for multinational businesses. It would be a great help if there is a way to automatically add exchange rates against the mentioned dates. As of now, I do this manually.