Unformated Dates

Hi Emma, thanks for your query.

Here's the formula we looked at in class which converts both 90210 and 100210 into date format. I've broken the syntax of the IF statement up to make it more readable here:

=IF(LEN(A1)=6,

(MID(A1, (LEN(A1)-5),2)) & "/" & (MID(A1, (LEN(A1)-3),2))& "/" & RIGHT(A1,2),

(MID(A1, (LEN(A1)-4),1)) & "/" & (MID(A1, (LEN(A1)-3),2))& "/" & RIGHT(A1,2))

I think you should be able to tease this apart, but let me know if you need any further help with this.

All the best,

Anthony