Hi All,
I have two columns of dates. But among each column few are in date format and others are in general format. I am not able to make into a uniform format. I have tried =Text(col1,"mm-dd-yyyy"). But its not working on few rows. Kindly help me solve the problem..
I have attached the sheet also.Datefunctions.xlsx
Bookmarks