Is there a formula or something in excel that will tell me the age of a person?

Question

I have a spreadsheet with a column that has the date of birth of about 300 people. I need the column to the right of that one to show the actual current age of the person. Anybody know how to do this?

Answer 1

Assuming A1 contains the DOB:

=RIGHT(YEAR(NOW()-A1),2)

Answer 2

Use the date functions.

Calculate the number of years between two dates
To do this task, use the YEAR function.

Example

1 Date
2 6/9/2007
3 6/4/2010

Formula Description (Result)
=YEAR(A3)-YEAR(A2) Years occurring between two dates (3)

Use the Today function to insert today's date as Year(A3)

Answer 3

yes, but u have to tell it how by entering the other info. Click the f-formula button at the top and type in the current month/year and a subtraction sign then click on the cell where the birth date is and then on the cell for where u want the info....you will have to change the format to date though

Answer 4

Sure. If cell A1 has the birthdate, you can go to cell B1 and type "=TODAY()-A1". The result will give you a number of days since that person's birth. Then, if you like, in cell C1, you can use "=B1/365" to get a number of years.

Answer 5

where: age=cell reference of persons date of birth
i.e. A1

=year(today()-age)

Answer 6

Check out the DatedIf function

http://www.cpearson.com/excel/datedif.htm

These instructions even show you how to break it down in years, months and days.

Answer 7

Well done -j but just to be more exact, divide by 365.25 days, to account for leap years

Answer 8

just do =SUM(B2-B1)

Whats left will show the age..

B1= the age of the person (eg. 1967)
B2=the current year

So If you do this then it will show you the age!