If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating age from birth dates
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 |
#2
|
|||
|
|||
Calculating age from birth dates
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|