Date format issue in excel file

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

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

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

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

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

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.