I agree with the date ranges. Not sure how to put all of this together in a script. Any help is appreciated, I will keep plugging away at it. Thanks
I have enclosed the definition of turnover.
Calculate your turnover rate
For the last 12 month period, add up the number of voluntary resignations. Next divide
by the total number of employees at the end of the same 12 month period.
• Resignations =
• Number of Employees =
• Your Turnover rate = % (divide resignations by number of
• Resignations = 55
• Number of employees = 500
• 55 ÷ 500 = .11 or 11%
And how is all that recorded in records of your table?
I have an employee table, I have hire date and term date. About all I have as not sure of the best way to move forward.