Get HR Software

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
From India, Ahmadabad
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)

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
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.


India, Ahmadabad
30 March 2010 04.21.14 AM
Views: 4845 Replies: 3 Appreciations: 0
#Excel Formula
Help Needed To Calculate On Excel - Xls Download
31-01-2013 | India, Pune
Removing Unwanted Characters And Spaces From Text - Excel Tips
21-08-2014 | India, Chennai
Excel Formulas - Xls Download
29-01-2016 | India, Hyderabad




Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.