Convert YYYYMMDD to date

If a date is stored as text in A2 having this format (eg. 20180624) you can convert it to a date format using:

 
 
  1. =DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))

Of course, you can use text to columns to get the data as date:

1) Select Delimited

2) Use Other as Delimiter but do not add any letter

3) Select Date, YMD and the destination

Add a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.