changing date formats
 

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

changing date formats
 

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.

In article .com,
Heine wrote:

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

changing date formats
 

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

"Heine" wrote in message
oups.com...
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

changing date formats
 

On May 3, 2:53 pm, JE McGimpsey wrote:
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.

In article .com,



Heine wrote:
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- Hide quoted text -

- Show quoted text -

It works great - thanks a lot

--
Heine

changing date formats
 

"David Biddulph" wrote:

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

"Heine" wrote in message
oups.com...
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



excellent
H S SHASTRI

INDIA