Forum Discussion
Solved
How can I extract or convert text data into date?
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...
- Assuming that first row is in cell P2, use =DATEVALUE(P2) You could then go further with =YEAR(DATEVALUE(P2), etc.
Assuming that first row is in cell P2, use =DATEVALUE(P2) You could then go further with =YEAR(DATEVALUE(P2), etc.