Calculating age from birth dates

[Tracy]

Hi does anyone know how to calculate age from birth dates
in excel (e.g. 13/07/1983 = 20). I need to work out the
ages of 2000+ people and the data I have is in birth date
format. It will save a lot of work and time if I can key
in a formula and convert them straight away.

Thanks,
Tracy

 

[Dave Ramage]

Tracy,

Assuming you want only completed years, try this:
=DATEDIF(A2,NOW(),"y")

....where A2 contains the birth date. Enter it into the
first cell, then copy down the colum for the other 1999!

For general information on how Excel handles dates and
times, see Chip's page here:
http://www.cpearson.com/excel/datetime.htm

Cheers,
Dave.

 

[Tracy]

Thanks Dave, that's excellent, you've saved me a lot time
and effort.
Tracy )

 

[John Nall]

I need help with a similar problem. I am making a spreadsheet with the
names, DOB, and DOD dates for persons in a church cemetery. I am having
trouble with Excel recognizing dates prior to 1900 as dates. I would
also like to compute the date aged in years, moths, and days if it is
possible. Any help would be greatly appreciated.

 

[Myrna Larson]

As for Tracy's problem, she seems to want the age in completed years. The formula for that is

=DATEDIF(A1,A2,"y")

where A1 contains the birthdate and A2 the 2nd date. If you want the current age, use something
like

=DATEDIF(A1,TODAY(),"y")