pm444
1

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
ashok.jangra
36

Please find attachement may be usefull but I fail to understand your query
From India, New Delhi
Attached Files (Download Requires Membership)
File Type: xls Years calculation..xls (13.5 KB, 1172 views)

santosh.henery
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
sriiir
3

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
From Canada, Montreal
Attached Files (Download Requires Membership)
File Type: xls Years calculation.(1).xls (13.5 KB, 672 views)

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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.