How do I calculate a person's age from date of birth and a date

C

Chez 27

Hello. I want to insert a formula into an Excel cell the will calculate a
person's age in years only from the person's date of birth at any given date.
For example, one cell will have date of birth, (27/04/60) and another cell
will be a date, (07/12/08); the formula in a different cell will calculate
that the person's age is 48.
 
D

DDD

Put the date of birth in one cell e.g. A1

Put the date you want in another cell e.g.B1 (For todays date type in "
=Today() " )

In the cell you want the age in type " =(B1-A1)/365.25 "

B1-A1 will work out the age in days (This works if the date in B1 is after
the date of birth) . Since there is 365.25 days in a year, divide the number
of days by this.

You can format the cell to have 0 decimal places afterwards.
 
D

David Biddulph

But of course there aren't 365.25 days in any year. There are 365 in most
years, and 366 in others. Hence better to use DATEDIF.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
How do I calculate a persons age from birth dates 1
date of birth age formula 8
Calculate age 3
Calculating age from date of birth and ignoring if blank 3
Calculating When Somebody Reaches a Certain Age 4
date of birth or blank cell? 3
Date Functions 5

Top