Dave's suggestion would result in a formula of

=DATEDIF(AVERAGE(A1:A100),TODAY(),"y") & " years, " &
DATEDIF(AVERAGE(A1:A100),TODAY(),"ym") & "months, " &
DATEDIF(AVERAGE(A1:A100),TODAY(),"md") & " days"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"yvonneb" <yvonneb@discussions.microsoft.com> wrote in message
news:6AC29BBD-27B4-444D-9F67-00882A73F4A1@microsoft.com...
> I'm trying to get an average "length of service" for staff. I've tried
your
> suggestion but can't get it to work. The formula I'm using is:
>
> =DATEDIF(D5,TODAY(),"y") & "." & DATEDIF(D5,TODAY(),"ym")
>
> Any additional tips please?
> 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 ****-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
> >