Calculating dates

[Guest]

I have a spreadsheet that lists separate periods of employment. Ex:
03/29/84 05/13/84
05/14/84 09/18/85
09/19/85 01/31/96
I'm using the following formula to calculate each row each in a separate
column:
Years Months
Days
=YEAR(B3)-YEAR(A3), =(MOD((B3-A3),365.25))/30.4, =DAY(B3-A3)

What formula would I use to calulate the cumulative total of all of the rows
based on the output received for years, months and days?

 

[Sandy Mann]

Tanya,

For your months and days you would be better to use the DATEDIF function as
in =DATEDIF(A3,B3,"ym") for months and =DATEDIF(A3,B3,"md") for days. If
your dates are consecutive then you can combine them all for a total as in :

=DATEDIF(A3,B5,"y")&" Years "&DATEDIF(A3,B5,"ym")&" Months
"&DATEDIF(A3,B5,"md")&" days"

which will return "11 Years 10 Months 2 Days"

You can find more info on DATEDIF in

http://www.cpearson.com/excel/datedif.htm

HTH

Sandy