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.