Translations:Adventist Youth Honors Answer Book/Arts and Crafts/Genealogy/28/en

Determine the age at death of each individual by subtracting the date of birth from the date of death. This is most easily accomplished by use of a spreadsheet program. To do this, create four columns, and label them Name, Birth, Death, and Age. Date for the first three columns should be entered in directly. Enter dates in the form:

"11/26/1827"

Be sure to enter a four-digit year, especially if it occurred more than 50 years ago. For the age column, assuming you are on row 2, enter the formula

=(C2-B2)/365.24

This will make the spreadsheet calculate the person's age at death. Once you've entered that into one cell, you should be able to copy it into the others (select the cell, type ctrl-C - then highlight a column of cells and type ctrl-V. This will paste it into each highlighted cell and automatically adjust the cell references for you). The result should look something like this: