Converting unhelpful date format into helpful one?
 

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

Converting unhelpful date format into helpful one?
 

Hi Darran,

Try

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

and apply the required date format.

Dave

"Darran" wrote:

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

Converting unhelpful date format into helpful one?
 

Amazing! Works perfectly, many thanks,

Darran

"Dave Curtis" wrote:

Hi Darran,

Try

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

and apply the required date format.

Dave

"Darran" wrote:

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

Converting unhelpful date format into helpful one?
 

Another one:

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



Darran wrote:

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 Peterson

Converting unhelpful date format into helpful one?
 

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

"Darran" wrote in message
...
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

Converting unhelpful date format into helpful one?
 

DataText to ColumnsNextNextColumn Data FormatYMDFinish


Gord Dibben MS Excel MVP

On Tue, 17 Mar 2009 04:36:01 -0700, Darran
wrote:

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