What is the difference between “Average for year” and “Year ended” in the Forex Worksheet?

The difference between “Average for year” and “Year ended”, is the flexibility of days.

If using the last day of the year (i.e. Dec 31), the rate will be the same, but “Year ended” would allow you to use Oct 1 – Sept 30, for example.