Hello, i’ve an input excel file with random date format (ddMMyyyy OR dd/MM/yyy OR ddMMyy, etc.), considering that I’ll have to make a comparison between dates, for example calculating if it is greater or not to another date, how can I convert it in the correct way not knowing before the format?

Question related to date type

Palaniyappan (Forum Leader) March 11, 2022, 2:47pm 3

Here you go similar scenario with sample workflows

Topic		Replies	Views
How do I parse in multiple datetime format strings into DateTime? Activities excel	12	4460	September 23, 2020
Date Format conversion issue in excel Activities excel , activities , question , vba , linq-query , invoke-vba	5	340	January 6, 2024
Help required to change date format Studio studiox , question	11	2868	March 6, 2021
How to convert excel column (string) to date format Studio	7	3505	June 8, 2022
Changing Column Type to Date Format Help excel	8	6874	March 31, 2020