Give something like this a try...

=TEXT(A1,"0000-00-00")-TEXT(B1,"0000-00-00")

where B1 contains the earlier date and A1 contains the later date.

--
Rick (MVP - Excel)


"ak_edm" wrote in message
...
There's no slashes or dashes between the year-month-day or the
month-day-year
parts of the numbers? It's literally "20080331" or "3312008"?

"Kiba" wrote:

one column formatted that way rest are 3312008.

"Kiba" wrote:

I have several columns with dates that are formated 20080331. I need
across
the row I need to figure the difference in those dates to find how long
it
took at different stages of the process. Ahy ideas?