Your data shows two characters for the month. Is there any difference betwnn
March and May or between June and July?
--
Gary''s Student


"bill gras" wrote:

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