Change col A to mm/dd/yyyy instead of dd/mm/yyyy. Excel reads it as mm/dd, note how A10 is 5/11, excel thinks it's May 11.