formula

Use metrics to monitor the health of your workforce. Some of the most important and most difficult figures to calculate are those that involve human capital. Here's a list of Excel formulas to give you the boost you need!

Annualized Turnover

=(Ending headcount – Starting headcount) / Average Headcount ) * (12 / # of months remaining in the year)

Length of Service
a. Column A – Name
b. Column B – Date of Hire