Extracting dates

[Sean15]

Hi:

I want to extract dates (mm/dd/yy) from data formatted as follows:

Thu, Sep 17, 2020 3:25 PM
Thu, Oct 29, 2020 8:31 AM

Required values should be
09/17/20
10/29/20

Could you help please?

Regards,
Sean

 

[Tetra201]

Try using the following formula in a cell formatted as mm/dd/yy:

=INT(REPLACE(A1,1,5,""))

 

[JoeMo]

Another way. Format col B as Date.

Book1.xlsm
	A	B
1	Thu, Sep 17, 2020 3:25 PM	9/17/2020
2	Thu, Oct 29, 2020 8:31 AM	10/29/2020
Sheet9

Cell Formulas
Range	Formula
B1:B2	B1	=DATEVALUE(MID(A1,5,65))

 

[Tetra201]

Or even shorter:

=--MID(A1,6,12)

 

[alansidman]

And yet another = Int(A1)

 

[Sean15]

Excellent, thank you very much.
@alansidman - formula is returning #Value!

 

[Peter_SSs]

Seems like OP & helpers must all be using US date system as none of the formulas work for me (d/m/y system).

@Sean15
For the future, with any date questions it is a good idea to
- state in your question what your system date format is as helpers can be anywhere in the world using a different system
- include examples that indicate whether day (& month if not text like yours) are always 2-digits or may be single digit (eg Nov 4, 2020 or Nov 04, 2020)

 

[alansidman]

Sean
Are you values true dates (ie. Numbers) or Text? I'm guessing from your response that they are text.