trim date from column 1 using a calculated column 2

[huggytn]

Column 1
6.0.2014-06-06T18:00:00Z

Column 2
2014-06-06

I also want to add in my calculation in column2 to convert the date to a format of (TODAY)

Thanks in advance,

Huggy

 

[Daveydoodles]

Does =DATEVALUE(MID(A1,5,10)) work for you?

Then change the cell to date format

 

[huggytn]

Does =DATEVALUE(MID(A1,5,10)) work for you?

Then change the cell to date format

Thanks Doodles - That worked out fine. Huggy