Age

  • Thread starter Thread starter Kiba
  • Start date Start date
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?
 
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"?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to select no.'s in a column that differ by <1 1
Calculating age 1
Calculate Age 2
Calculate age 3
Calculating How Old Someone Will Be in a certain year 2
Excel Macro for deleting Rows containing dates greater than "today" 0
putting peoples' ages in age groups...? 2
Display the days between start & end date columns 3

Back
Top