CURRENCYH function on weekends
I'm having a problem using the CURRENCYH function for historical currency rates. If the date field is a weekend, the formula returns an error. Instead, I'd need it to use Friday's closing price. Any thoughts?
I suppose I could create a nested IF/THEN statement so that if an error is returned, it subtracts 1 from the date, and if that returns an error, it subtracts 2. But was hoping for a more elegant solution.
MacBook Pro 15″, macOS 11.6