changing date formats

[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

 

[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.

 

[David Biddulph]

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

 

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

It works great - thanks a lot

 

[Guest]

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




excellent

H S SHASTRI

INDIA