I have this application which will clean bank statements and customize the sheet in the required format. I have 2 kinds of files to convert in which the dates displayed are different in each format. (Test, Test2). The test2 sheet dates are giving the correct result but the test sheet is not converting the dates in the required format. Instead of 1st october it is displaying 10th january in the dd-mm-yyyy format. The issue is in the dates from 1st to 12th of every month. Can someone please help me to correct the code and get the correct result in both the cases.?
After pressing the customize button check the date column of CleanData sheet. That is the only problem to be solved.