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
From India, Ahmadabad
1From India, Ahmadabad
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
From India, Lucknow
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
From India, Lucknow
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
EXCEL FORMULA.xls