Multiple Date format in excel issue

[krishna20]

Hi Folks,

I am having excel data which holds date in two different formats. Tried Date,Date#,alt,floor functions but no luck.

Can anyone look into this and light up on this issue. Sample data has attached.

Regards

Krishna

[lironbaram]

hi 

this should do the trick for you 

if(index(Date,'-')>0,date(date#(Date,'MM-DD-YYYY')),date(Date)) as NewDate,

[krishna20]

Hi LironBarom,

Thanks for your valuable suggestion , few dates are not showing right format. I want in 'MM/DD/YYYY'.

Attached screenshot for reference. 

[lironbaram]

hi 

you can change the date format to MM/DD/YYYY in the function 

in your excel some of the dates aren't in January