1. =e4-d4 gives you the number of days the person has been on staff.
2. Copy this down for all staff members
3. Average this range.
4. If you want to display the result the same way, you can use:
=DATEDIF(0,a1,"y") & " Yrs, " & DATEDIF(0,a1,"ym") & " Months"
where a1 holds the average.

Regards,
Fred


"SGee" wrote in message
...
I am trying to find an average length of employment for a group of
employees
at the time of their promotion. I am using the formula below to calculate
each employee's time in service at the date of promotion:

=DATEDIF(D4,E4,"y") & " Yrs, " & DATEDIF(D4,E4,"ym") & " Months"

whe
D4 = beginning employment date
E4 = promotion date

What I would like to do is average the time on the job for the employees
promoted in each group. I cannot simply average the column due (I think)
to
the text in the output.

Any suggestions would be most appreciated. Thanks

Scott