Excel Formula Require - Xls Download

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

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, 1158 views)

Oh.. file not attched.
Put Data in cells as below
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 you 33 in C2 and 11 in D2
HTH
30th March 2010 From India, Lucknow

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, 665 views)