|
|
Use the days only to average and then convert to years etc
--
Regards,
Peo Sjoblom
(No private emails please)
"UTCHELP" wrote in
message ...
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...
--
UTCHELP
------------------------------------------------------------------------
UTCHELP's Profile:
http://www.excelforum.com/member.php...o&userid=27894
View this thread: http://www.excelforum.com/showthread...hreadid=473980
|