MOREY54
New member
Sep 7 2015 8:23PM
Thank you
Thank you
I need to convert Sep 7 2015 8:23PM to 08/07/2015
If text string in A1 then tryI need to convert Sep 7 2015 8:23PM to 08/07/2015
=CHOOSE(MATCH(MID(A1,1,3),{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Nov","Dec"},0),1,2,3,4,5,6,7,8,9,10,11,12)&"/"&VALUE(MID(A1,FIND(" ",A1,1),3))&"/"&VALUE(MID(A1,7,5))
=DATE(VALUE(MID(A1,7,5)),CHOOSE(MATCH(MID(A1,1,3),{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Nov","Dec"},0),1,2,3,4,5,6,7,8,9,10,11,12),MID(A1,4,3))