What to do when you receive the Date format error while Importing?

When importing employees into the system with a hire date, the system may show an error stating 'The hire date column is not formatted as a date column or contains text that is not formatted as a date'. 

This is commonly an Excel issue - to make the file readable as "DD-MM-YYYY" follow these steps: 

1) In the Employee import Excel sheet, highlight the date column with the dates that are causing the error

2) Click the Data tab > Text to Columns

3) Choose the Delimited option

4) Click Next

5) Make sure all Delimiters are unselected

6) Click Next

7) Choose Date, then select "DMY" in the dropdown

8) Click Finish