I have a table where I am summing columns containing date information. The
table looks like:

E F G
years months days
1 2 9
0 5 6
29 0 0
0 6 2
total 32 2 0

the years, months, days information is found by the following formulas that
Pete_UK showed me last week (thanks again Pete the formulas they work great).
FYI (A9 is beginning date mm/dd/yyyy and C9 is ending date mm/dd/yyyy

years -
=DATEDIF(A9,C9,"Y")+IF(DATEDIF(A9,C9,"YM")+IF(DATE DIF(A9,C9,"MD")=14,1,0)10,1,0)

months -
=IF(DATEDIF(A9,C9,"ym")+IF(DATEDIF(A9,C9,"md")=14 ,1,0)=9,0,DATEDIF(A9,C9,"ym")+IF(DATEDIF(A9,C9,"m d")=14,1,0))

days - =IF(DATEDIF(A9,C9,"md")=14,0,DATEDIF(A9,C9,"MD"))


The problem I am now encountering is this: When the days column =15 days I
am to add 1 to months and then return 0 in 'days total' or =45 days then add
2 and then return 0 in 'days total', else return sum total of column C; then
when the months column is =9 then add 1 to year and return 0 unless the
total months is between 13 & 16 then you would add 1 to year and return the
difference between the total months-12 (you would then repeat this process
for each multiple of 12 months (add 2 years and then return months; if total
months are between 9 and 12 you return 0 to months total) or if total months
is < 8 then return sum of months column

I have shown, in the example above, what the total should look lilke but
have been unable to get it. This really has me stuck. Thanks for any help


LAMP