ExcelBanter - Sum of dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sum of dates (https://www.excelbanter.com/excel-worksheet-functions/23261-sum-dates.html)

I posted this question yesterday, (and yes, I realized my calculation error
after I posted. But, thanks for the corrections) but I may not have been
clear about what information I am trying to calculate. My spreadsheet is
formatted as follows:

A1 B1 D1 E1 F1
From To Years Months Days
10/16/198512/31/1989 4 2 16
1/1/1990 10/11/1990 0 9 11
2/19/1991 9/30/1991 0 7 12
Total 4 18 39

To get the years, months and days I am using the following formulas:
=DATEDIF(A4,B4,"Y"), =DATEDIF(A4,B4,"YM"), =DATEDIF(A4,B4 +1,"MD")

I now need the formula to convert the 4yrs, 18mos, 39days into 5yrs, 7mos,
30 days or 5yrs, 8mos preferrably. (Did I get it right this time?) :)
Thanks for your help!

Assume the sums of rows 2,3 and 4 are in D7, E7 and F7....
D8 = D7+INT(E7/12)
E8 = MOD(+E7+INT(((F7-F8)/30)),12)
F8 = MOD(F7,30)

HTH,
Gary Brown

"Tanya" wrote in message
...
I posted this question yesterday, (and yes, I realized my calculation error
after I posted. But, thanks for the corrections) but I may not have been
clear about what information I am trying to calculate. My spreadsheet is
formatted as follows:

A1 B1 D1 E1
F1
From To Years Months Days
10/16/198512/31/1989 4 2 16
1/1/1990 10/11/1990 0 9 11
2/19/1991 9/30/1991 0 7 12
Total 4 18 39

To get the years, months and days I am using the following formulas:
=DATEDIF(A4,B4,"Y"), =DATEDIF(A4,B4,"YM"), =DATEDIF(A4,B4 +1,"MD")

I now need the formula to convert the 4yrs, 18mos, 39days into 5yrs, 7mos,
30 days or 5yrs, 8mos preferrably. (Did I get it right this time?) :)
Thanks for your help!