Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
this should do the trick for you
if(index(Date,'-')>0,date(date#(Date,'MM-DD-YYYY')),date(Date)) as NewDate,
Hi LironBarom,
Thanks for your valuable suggestion , few dates are not showing right format. I want in 'MM/DD/YYYY'.
Attached screenshot for reference.
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