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

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, 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
30th March 2010 From India, Lucknow

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

Other Discussions That May Be Relevant

Need formula/procedure for epf / pf calculation excel file

Facing formula insert problem in excel merged columns - xls download

Attendance format in ms excel with the formula of over time?

Related Files & Downloads Shared By Members

 EXCEL FORMULA.xls

 Excel Formula.xls

 Required formula in excel.xls

Interest Tags

Trending Tags

Trending

Excel Formula Require - Xls Download

Login Or Register