Help with formula

[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

 

[Bob Phillips]

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)

 

[Snergle]

Well OK. But, may I assume that months have fixed number of days. (30 days
per month).

 

[Bob Phillips]

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)

 

[Snergle]

OK, got it

thx

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)