You could use:
=AVERAGE(A1:A10*1)
Array-entered, meaning press ctrl-shift-enter.
But you could also just change your current formula to:
=1*(DATEDIF(A1,NOW(),"y") & "." & DATEDIF(A1,NOW(),"ym"))
Then just use:
=AVERAGE(A1:A10)
which is *not* array-entered.
HTH
Jason
Atlanta, GA
-----Original Message-----
We are using the formula =DATEDIF(A1,NOW(),"y") & "." &
DATEDIF(A1,NOW(),"ym") to calculate the years and months
from an employee
hire date.
Is there an easy way to average the years and months for
a group of
employees with the results of that formula?
.
|