Total years mounths and days elapesed from todays date

[Guest]

I will have a database where their birthday is included in the registration. I wish to total all the years we have in attendance. should ouput like 800 Years, 8 Mounths and 22 days. I could sum the days and devide by 12 (Mounths) but what would I do with the left over.

 

[Stephen Bye]

1) Use the TODAY function to calculate
number of days old = Current date - birth date
for each person.

2) Sum these to get the total number of days.

3) Then use:
=INT(B21/365.25)&" years "&TEXT(B21,"m ""months"" d ""days""")
to get the total number of years, months and days.
(Change the B21 cell reference to the cell containing your total).

I will have a database where their birthday is included in the

registration. I wish to total all the years we have in attendance. should
ouput like 800 Years, 8 Mounths and 22 days. I could sum the days and devide
by 12 (Mounths) but what would I do with the left over.