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

Acknowledge(0)

Amend(0)

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

Acknowledge(0)

Amend(0)

santosh.henery

Oh, the file is not attached.

Put the data in cells as follows:

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 33 in C2 and 11 in D2. HTH
30th March 2010 From India, Lucknow

Acknowledge(0)

Amend(0)

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

Acknowledge(0)

Amend(0)

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.

Other Discussions That May Be Relevant

Help me for any advanced excel format / any software for payment details
Dear all can anyone suggest to me? i m working in a manufacturing company. apart from tally software can you all suggest any excel format where we can enter all...

Can you believe this best websites in one excel sheet !!!!!!
Hi friends a very good day to one and all. hope you are doing well. please find attached the excel sheet here you can find all most all helpful...

Interest Tags

Trending Tags

Trending

Excel Formula Require - Xls Download

Login Or Register