How can I extract or convert text data into date?

[Anthony_Luk]

Hi there,

The data and time data as below is written as text. I'm unable to convert it into date format in order to process further analysis such as =year or = month.

Kindly please advise.

Many thanks

[#2 · Accepted solution]

Assuming that first row is in cell P2, use =DATEVALUE(P2) You could then go further with =YEAR(DATEVALUE(P2), etc.

[#3]

@mathetes 

Thanks for your advice 

[#4]

Try this:
=LET(p,P2,LEFT(p,FIND(" -",p))*1)

Then format cell with custom code: yyy-mm-dd hh:mm:ss