Forum Discussion
Change date text formatted as dd/mm/yyyy hh:mm:ss AM/PM into date serial no.
I have raw cvs file dump with text strings I need to return in a new column with the date/excel "serial number": the cell contains for example: "23/07/2019 12:12:11 PM" I need to return a serial da...
That's a tricky one, because the dates are displayed in a European manner.
If it were "7/23/2019 12:12:11 PM"
then this formula works easily
=DATEVALUE(LEFT(A1,FIND(" ",A1)))
But with "23/07/2019 12:12:11 PM" it returns an error message.
It certainly is possible to parse the date and convert it to separate numbers for month, day and year....but I'm hoping there's somebody else here who can do something more directly.