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
|