Text date to date in Excel

[Volkof]

Hi Excel users,

here is an old question.

Convert a text date to a date. I have the following text: Wednesday, May 23, 2018
This needs to be converted to a date: 23.05.2018.

I have separated every variable: Day ( Wednesday) Month and Year using text function but I don't know how to proceed further.
Please help.

Thanks.

 

[jtakw]

Hi,

You can do this:

Book1
	L	M
1	Wednesday, May 23, 2018	23.05.2018
2
3		M1 custom formatted as dd.mm.yyyy
Sheet61

Cell Formulas
Range	Formula
M1	=MID(L1,FIND(" ",L1)+1,255)+0