U
UTCHELP
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...
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...