Need help with date conversion formula

[Pat1009]

Hello Board,
I was using this formula =0+MID(C2,5,6) to convert this Mon Dec 11, 2017 into this 12/11/2017. It worked up until 2018 came along. If I use it now, it will convert this....Mon Dec 11, 2017 to this, 12/11/2018.
please let me know what is wrong.

 

[macattackpro]

Your formula only pulls out the "Dec 11" part of your cell. Excel wants to default to the current year when not specified. Try this instead:

=DATEVALUE(RIGHT(C2,LEN(C2)-FIND(" ",C2)))

 

[Pat1009]

excellent, that did the trick, thank you