Whilst searching the online templates from Microsoft, I came across a great “any year calendar” – a calendar that can be re-used year-on-year.

However, when I started using it, I came across a problem due to the way my computer is configured. My computer is set up as UK (well it would be) which means that Excel expects dates to be in day-month-year format, whereas the template is set up to use month-day-year format.

In this video I explain how to amend the formulas in the spreadsheet to make it useable in the UK. Funnily enough a customer sent me a very similar spreadsheet 2 days later with exactly the same problem!