Calculating age from birth dates
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")
On Mon, 15 Sep 2003 02:14:00 GMT, John Nall wrote:
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.
Tracy wrote:
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
|