Need Help with Excel Formula to Calculate Age and Years of Service for Employees

Dear All Seniors, Pls require excel formula of Age & No. of service of Years of following dates. Name : Rakesh Amin DOB : 02.02.1977 DOJ : 08.09.1999 Thanks & Regards, pm
30th March 2010 From India, Ahmadabad

Acknowledge(0)

Amend(0)

Add Reply → Start New →

ashok.jangra

Please find attachement may be usefull but I fail to understand your query
30th March 2010 From India, New Delhi

Attached Files (Download Requires Membership)

Years calculation..xls (13.5 KB, 1183 views)

Acknowledge(0)

Amend(0)

santosh.henery

Oh, the file is not attached.

Put the data in cells as follows:

CELL: A | B | C | D |
1: DOB | DOJ | Age | Ser. years |
2: 22/02/1977 | 08/09/1999 |
Put in C2: =YEAR(NOW())-YEAR(A2)
Put in D2: =YEAR(NOW())-YEAR(B2)

It should show 33 in C2 and 11 in D2. HTH
30th March 2010 From India, Lucknow

Acknowledge(0)

Amend(0)

sriiir

Hi pls find the attached sheet it will be useful i hope. while using the formulae to get the age as whole numbers format the cells by number value decimal point "0". Thanks Sri
30th March 2010 From Canada, Montreal

Attached Files (Download Requires Membership)

Years calculation.(1).xls (13.5 KB, 673 views)

Acknowledge(0)

Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.

Other Discussions That May Be Relevant

Eps member completing his service of 10 years - how is the further pension calculated?
Dear expert i have a question: will an eps member who has completed ten years of service and has not yet reached the age of 58 still work? how is...
8 Replies 1 Files 4 Participants

Managing age calculations and employee age limits: excel tips and government regulations
Dear all you can use it to calculate the appropriate age of a person. it s very useful. regards pooja...
4 Replies 1 Files 3 Participants

Gratuity - if any employee completes your service of 20 years and 6 months then how many years will the gratuity be calculated on?
Hi all i am sumit sharma and i have a question. if an employee completes 20 years and 6 months of service how many years will the gratuity be calculated...
5 Replies 0 Files 3 Participants

Gratuity for 4.8 yrs and 18 days - how the calculation is to be done?
Hi if gratuity is eligible for 4.8 years then please share how the calculation is to be done for 4 years 8 months and 18 days....
4 Replies 0 Files 4 Participants

How to calculate average in excell attached - rar download
Dear friends please find the attached excel sheet and instructions on how to calculate the average. it s very important. if there is any formula please let me know as...
2 Replies 1 Files 2 Participants

Understanding gratuity calculation and rounding rules for completed years of service
Please let me know if a fraction of a year is rounded off to the nearest year for calculating completed years for gratuity in india. for example in the case...
2 Replies 0 Files 3 Participants

Is he eligible for a gratuity of 7 years or 8 years after 8 years of service?
Dear concerned i have a query on gratuity. an employee s service in our organization is of 8 years. in the last year his present days are less than 240...
6 Replies 0 Files 7 Participants

Related Files & Downloads Shared By Members

 Age Character Calculation.xls

 Age Character Calculation.xls

 Age Character Calculation.xls

Need Help with Excel Formula to Calculate Age and Years of Service for Employees

Human Resource Management (HRM) Community Journal & KnowledgeBase (Entry: 243297)

TOP ENTRIES ON SUBJECT

Interest Tags

Trending Tags

Need Help with Excel Formula to Calculate Age and Years of Service for Employees

Login Or Register

Human Resource Management (HRM) Community Journal & KnowledgeBase (Entry: 243297)

TOP ENTRIES ON SUBJECT