Converting unhelpful date format into helpful one?

D

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
 
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
 
D

Darran

Amazing! Works perfectly, many thanks,

Darran

Dave Curtis said:
Hi Darran,

Try

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

and apply the required date format.

Dave
Click to expand...
 
D

Dave Peterson

Another one:

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

Gord Dibben

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


Gord Dibben MS Excel MVP
 
Top