Not sure where you're getting the 9 months from, but it's .98*** of
365 days, or 357 days, which most definitely falls in December, or 12
months.

I don't know if there's an easier way to calculate, do most of my work
in VBA, not on spreadsheets. Good luck, I'll visit this again to see
if somebody smarter than me posted the answer.

-np


On 7¤ë16¤é, ¤È«á12:37, boxersrfun
wrote:
I need to find the average age of a group of people, by years and months.
For example if I need the average age of for these birthdays (3/19/90,
2/10/92, 12/3/89 and 1/12/90. I need an result like 17 years and 9 months.
Not just the average year.

I determined the number of days old each person was and then averaged the
days and divided by 365 and came up with 17.98013699. Is 17 yrs 9 months an
accurate interpretation? Is there an easier way to calculate?

Thanks for your help.