Refer below steps to resolve date formatting issue while processing data.

Step 1:- First of all select the Columns containing the “dates”

 

Date format issue in Excel

 

Step 2: Select Text To Columns. You’ll find this on the DATA tab/menu, depending on which version of Excel you are using.

 

Date format issue in Excel

 

Step 3: Ensure that the original data type is set to Delimited and click Next

 

Date format issue in Excel

 

Step 4: Ensure that all the check boxes are clear and click Next

 

Date format issue in Excel

 

Step 5: Set the Column Data Format to DMY and Click Finish button this format is DD/MM/YYYY is format is correct date format.

 

Date format issue in Excel

You might be interested in our other Products / Services