The info you've given so far is excellent - thanks, and I have been using the
"NOW" instead of TODAY.

Now i have a new twist on the same theme. I want to calculate the average
length of service of ex-employees. I'm using the following:

J8 = start date (2-Nov-04)
K8 = leaving date (6-Sep-05)

=DATEDIF(J8,K8,"y") & "." & DATEDIF(J8,K8,"ym")

which gives me a result of 0.10 (0 yrs/10 mths)

I have a column of results in yrs/mths which I want to average out. Can
this be done?
Many thanks
Yvonne



"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