Age
 

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?

Age
 

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?

Age
 

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?

Age
 

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?