tenure calculations

  • Thread starter Thread starter djackson
  • Start date Start date
D

djackson

how can I format several dates such as 04/19/2003, 04/01/2004, etc. int
a yearly average for the employee tenure
 
right now say I have my yearly figures in i1-i9. The formula I though
would work is

=today()-average(i1:i9), but how would i format this to give me
yearly read out
 
Hi djackson!

One way is to use YEARFRAC with a third argument of 1 to get your
tenures in years and fractions of a year and then average the result.
However YEARFRAC does produce some annoying but small errors.

You method formatting the result yy mm dd produces a result that is
difficult to interpret.
 
Back
Top