Nearly 11 years later and I had this exact same issue and could not find the answer anywhere. There's an opportunity to get the F1 help file down to this level. Anyway, the format I used in Excel was "yyyy-mm-dd" and that (finally) imported the data correctly.