Last Updated on December 15, 2013 by ShumailaKamal
Today I am publishing here a detailed article on How to Calculate Total Length of Service & Age for all the Employees in MS Excel Sheet. You can easily find out the total length of service and age for an employee or a group of employees.
Method to Calculate Total Length of Service
Just simply enter the date of Appointment of an employee in the concerned column. In the same way enter the date on which you want to find the total length of service. Remember the sequence of the date will be as under:
You must separate the month, day and year by “/” not by “-“.
Method to Calculate Total Age or Age Difference
You can also find the age difference by using this simple formula. Enter the date of birth in the column of “Date of Appointment” and in the same way enter the date on which you want to find the age of an employee or a group of employees. If you have any difficulty in this process you can comment here so that I may see the situation. I have already published a post regarding “Formula to Calculate the Age in MS Excel Sheet “. If you find any difficulty by using that technique you can try this formula. This post has been delivered by Mr. Hamid Mosvi.