Age

K

Kiba

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?
 
A

ak_edm

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"?
 
R

Rick Rothstein

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.
 
Top