Total years mounths and days elapesed from todays date

N

noremark

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.
 
S

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).

noremark said:
I will have a database where their birthday is included in the
Click to expand...
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.
 
Top