Formatting of the dates

[srkj]

month/date/year ----> yearmonthdate
05/15/2012 --> 20120515
4/1/12 --->20120401
6/03/12 ---> 20120603
07/05/2012 ---> 20120705

hello

I am trying to convert some dates that can exist in multiple formats into a single representation

the dates can exist in different forms as listed in column A and column B reflects the new format.

any help or tips are appreciated

thanks

 

[Jonmo1]

If the Dates are real dates, then try

=TEXT(A1,"yyyymmdd")

 

[Rick Rothstein]

month/date/year ----> yearmonthdate
05/15/2012 --> 20120515
4/1/12 --->20120401
6/03/12 ---> 20120603
07/05/2012 ---> 20120705

hello

I am trying to convert some dates that can exist in multiple formats into a single representation

the dates can exist in different forms as listed in column A and column B reflects the new format.

Give this formula a try...

=TEXT(A1,"yyyymmdd")

 

[Asala42]

Try:
=YEAR(A2)&TEXT(MONTH(A2),"0#")&TEXT(DAY(A2),"0#")

It does assume that Excel will recognize the cell refrenced as a date

[edit] Withdrawn - Rick &Jonmo's got the better formula. Apparently I wanted to do it the long way

 

[srkj]

Thank you. =TEXT(A1,"yyyymmdd") did the trick