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