FxRate by NBP

Excel addin

FxRate addin gives you a handy way to leverage official NBP foreign currency exchange rates, straight in your Excel spread sheet

Compatible with Microsoft Excel desktop and online versions

Windows, macOS, Excel Online (Onedrive, Microsoft 365)

The function returns the exchange rate for a specific currency and a date

Including USD, EUR, GBP, INR, JPY and many more

When a date in the custom function falls on a holiday, the exchange rate from a previous working date used