Help with formula

  • Thread starter Thread starter Snergle
  • Start date Start date
S

Snergle

Hi everybody,
I've got a problem creating a formula. Have a table that looks like this.
A B C
John 13/05/2005 15/05/2006
John 13/05/2005 15/05/2006
Suzy 13/05/2005 15/05/2006
Suzy 13/05/2005 15/05/2006
Mary 13/05/2005 15/05/2006

Now, I want in colum "D" to have difference between these two dates. (e.g.
0years 2months 23 days).
Also in column "E" (or other sheet)want to calculate total of differences
betwen two dates for each Name seaparately, (e.g. Total John 2 years 2
months 3 days).
also, when adding new Names that they are calculated automaticaly in column
"E" (or other sheet).

Thanx
 
Subtratcting 1 date from another and reporting in that format is fine using
DATEDIF, but not summing, because months have different days.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Then that would return a difference of 1 year 0 months and 5 days between 1
Jan 2005 and 1 Jan 2006, which is clearly nonsense.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
OK, got it

thx
Bob Phillips said:
Then that would return a difference of 1 year 0 months and 5 days between
1
Jan 2005 and 1 Jan 2006, which is clearly nonsense.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
Click to expand...
 
Back
Top