I'm looking to carry out data profiling against data within excel worksheets

E.g.

Column A (Date) has 1000 rows of dates and I would like to know the patterns for this column

Example

dd/mm/yy
/mm/yyyy
ddmmyy
d/m/y

Is there a function or add in which can display the patterns in a column ?