Converting unhelpful date format into helpful one?

[Darran]

Can anyone suggest how I might convert a list of dates currently in the
General format of 20090210 (10th Fed 2009) to a more useful format so that I
can then run the =NETWORKDAYS() function.

Thanks

D

 

[Dave Curtis]

Hi Darran,

Try

=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))

and apply the required date format.

Dave

 

[Darran]

Amazing! Works perfectly, many thanks,

Darran

Hi Darran,

Try

=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))

and apply the required date format.

Dave

 

[Dave Peterson]

Another one:

=--text(a1,"0000\/00\/00")
and give it a nice format (mm/dd/yyyy)

 

[David Biddulph]

=--TEXT(A1,"0000\-00\-00") and format as date.

 

[Gord Dibben]

Data>Text to Columns>Next>Next>Column Data Format>YMD>Finish


Gord Dibben MS Excel MVP