Hi R Venkataraman
thanks for your imput
regards Bill
--
bill gras


"R.VENKATARAMAN" wrote:

plerhaps they are not <dates but texts.
you have to convert text to dates little difficult as the text is written
unless you chane each text into m/d/yy
particularly oct is written as oc.

if they are in csv or text format which can be divided into columns then
something can be done.
wait for a soluton by mvp

"bill gras" wrote in message
...
I'm stuck with a date problem I can not fix
I import a file that has s date column as follows:

18Oc05
27Se05
22Se05
13De04
6No04
7Oc04
17Ju04
and so on down to 1200 rows, I tried all sorts of cell formats but no luck
I need to have the difference in days between two dates. All I get is
#VALUE!

can some one please help

bill gras
--
bill gras