changing date formats

H

Heine

hello everybody

I have thousands of rows looking like this:

20060505
20070302
20050708

etc.

How can I change these to date formats so I can calculate the number
of days between these dates and another row of dates?

Any ideas?

regards
Heine
 
J

JE McGimpsey

One way:

Select a column of dates to be converted. Choose Data/Text to Columns.
Click Next, Next, then select YMD from the Date dropdown. Click finish.

Repeat for any other columns of dates.
 
D

David Biddulph

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
or
=--(TEXT(A1,"0000\/00\/00"))
 
H

Heine

One way:

Select a column of dates to be converted. Choose Data/Text to Columns.
Click Next, Next, then select YMD from the Date dropdown. Click finish.

Repeat for any other columns of dates.






- Show quoted text -
Click to expand...

It works great - thanks a lot
 
Top