The anal-retentive portion or the formula??? <vbg

(Could be either!)

Myrna Larson wrote:

BRILLIANT, Dave!!!

On Thu, 06 Oct 2005 20:14:32 -0500, Dave Peterson
wrote:

First, I think I'd use Today() instead of Now() (it just makes more sense to
me
and I'm kind of anal-retentive).

But couldn't you just take the average start date and do the datedif() stuff:

=datedif(average(a1:A100),today(),"y") & "years, "......



UTCHELP wrote:

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

--

Dave Peterson