Hi
Ann,
Calculating the age at death is actually quite simple in
Excel. You can use the
DATEDIF function to calculate the difference between the birth date and the date of death in years, months, and days.
Here's how you can do it:
- In Excel, create a new column next to the birth date and label it "Age at Death".
- In the first cell of the "Age at Death" column, enter the following formula:
Formula:
=DATEDIF(A2,B2,"y")&" years, "&DATEDIF(A2,B2,"ym")&" months, "&DATEDIF(A2,B2,"md")&" days"
(Note: A2 is the cell containing the birth date, and B2 is the cell containing the date of death. Adjust the cell references as necessary for your data.) - Press Enter to calculate the age at death for the first person.
- Copy the formula down to the rest of the cells in the "Age at Death" column.
The formula uses the
DATEDIF function to calculate the difference between the birth date and the date of death in years, months, and days. The "&" symbol is used to concatenate the results of the three
DATEDIF functions into a single text string.