MS Excel date conversion

With data in A1, try:

=DATEVALUE(LEFT(A1,10))

enter image description here

a slight change would be needed if you also needed the time =DATEVALUE(LEFT(A1,10))+TIMEVALUE(MID(A1,12,8))

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top