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
|