Hi, I am wondering please whether anyone can help me? I am currently tracing my Family History and would like to enter formulas into an Excel database containing information relating to my family members.

Firstly, I would like this database to contain the accurate current ages of my family members in 'Column J' upon entering a 'date of birth' in 'Column I'. However, if a date of death is entered into 'Column K', instead of providing a current age in 'Column J', I would like instead for this cell to display 'Not Living'.

Secondly, presuming a date of death has been entered in 'Column K', and a date of birth in 'Column I', I would like the spreadsheet to work out in 'Column L', the accurate age of the person at death.

Column B = Name
Column I = Date of Birth
Column J = Current Age
Column K = Date of Death
Column L = Age at Death


Thank you so much for your help!!