The requested historical date is invalid or is in the future.
B1 formula:
~somedate~
B2 formula:
CURRENCYH("USD","HKD",0,B1)
From my Mac (and today is 24-April-2021),
if the value of B1 is 12-April-2021 or earlier, the calculation is OK.
If the value of B1 is 13-April-2021 or later, this error is shown: The requested historical date is invalid or is in the future.
I remembered I may alter the calendar setting in System Preferences / Language & Region / General / Calendar from Gregorian to ISO 8601 about that time, but even I changed back to Gregorian the problem still persists. And I cannot find a way to reset Number's preference like Final Cut Pro.
Please help.
iMac 27″, macOS 10.15
