There are several ways to calculate turnover.
Once you determine how you want to calculate it then doing it
in Excel should be fairly easy. Some different approaches here...
http://www.incoming.com/WebModules/Q...ion.aspx?ID=64
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Gaurav"
wrote in message
Hi All,
What will be the formula for calculating the annual attrition rate?
We have separate rows for months where in we have Opening Balance, Closing
Balance, People Joined and People Left in different columns.
Help would be appreciated.
Thanks