I always make dates appear in dd-mmm-yyyy format or dd-mmm-yy
This solves most date translation issues.

You'll never be confused and excel will also never be confused with
12-Dec-2005