I have many excel files and in each excel I have a column under the name "dates". The date format is dd/mm/yyy and the data are monthly
01/03/2006 and so on
Since I have a large number of excel files (around 100) I want to see in each file if the sequence of dates is disrupted by mistakes
For instance, the below date sequence contains mistakes
Is there any way to identify these mistakes?
PS:Note that the start date and end date are different across files. So if you provide any code, please take into account that I need to be able to find the initial date "automatically"