Converting Numbers to Dates

[Savastano]

Using the bloomberg function for my work I am extracting numerous dates of data releases. These come in a strictly number format, as well as being in a funny order.

I.E. 20100214 is 14/02/2010
20110909 is 09/09/2011

Is there a formula to amend the numbers on the left in the example to a proper date format?

Thanks in advance

 

[jtakw]

Hi,

Try this, may not work if your region Date format is different than mine:

Book1
	A	B
1	20100214	2/14/2010
2	20110909	9/9/2011
Sheet563

Cell Formulas
Range	Formula
B1	=REPLACE(REPLACE(A1,5,0,"/"),8,0,"/")+0

Format result cells as "Date".

 

[ChrisGT7]

If 20100214 is in cell A1, try in B1 the following formula:
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

 

[Savastano]

Thank you this worked great.
@ChrisGT7 Appreciate it too, yours worked as well.

 

[Rick Rothstein]

Here is one more (it returns the date as a serial number, so you will have to format the cell with the date format of you choice)...

=0+TEXT(A1,"0000-00-00")

 

[jtakw]

You're welcome, glad they worked for you, you have many solutions to choose from.