I'm not sure this is even possible.

I am calculating the length of time someone has worked for the company:
Column; Row A1,
Hire Date MM/DD/YYYY

Column; Row B1,
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days"

Which gives me a result like: "4 years, 5 months, 10 days"

I want to be able to average the results from column B, thereby producing the average "years, months, and days" worked. Just not sure how to get there. Please help I'll loose my job... Ah, maybe not, but you know.

Thanks everyone...