How to calculate average length of service

[fayez_MrExcel]

I have 20 employees with their corresponding date of joining. How can i calculate the average length of service per employee as of todays date. Help please . thanks

 

[Smitty]

I suppose you could create a column to calculate LOS (=StartDate-Today()), then use AVERAGE() on that column.

HTH,

 

[fayez_MrExcel]

okay i'll try that...thanks

 

[mvptomlinson]

You can also use the array formula (confirmed with CTRL+SHIFT+ENTER):

=AVERAGE(TODAY()-B1:B20)

where B1:B20 contain the employee start dates.