separate into month, day and year

[ehardway123]

Hey all,

I am trying to separate these dates to have a column of there own, month day and year. The current format it is in is 150120 (year,month,day or YMD). what function do i use to separate it in powerpivot?

Thanks,

Etica

 

[JLGWhiz]

Assuming the date is in column A and you want the separated data in columns B, C and D respectively.
Starting in cell A2 Formulas As follows:
Cell B2:

=Mid(A2,3,2)

Cell C2:

=Mid(A2,5,2)

Cell D2:

=Left(A2,2)

Then select the the three cells in columns B.C and D and drag (copy) them down as far as you need them.

 

[shg]

Could you not just convert them to actual dates using text to columns and go from there?

 

[ehardway123]

I figured it out. Thank you! i used left and mid function.