Why does the result in the Forex Worksheet indicate “No Rate”?

Examples where the solution results “No Rate” include:

• The date may be a statutory holiday (“Average for day” only)
• The Bank of Canada does not have official data for this time-frame (e.g. EUR before 1999)