Hugo wrote:
I've discovered a pile of mortuary cards and I'm trying to put them in
an Excel file. But often is only the date of death and the age
mentioned, without the date of birth.
Does someone know a method in Excel to calculate that?

For instance: someone who died on february 12 1850 on the age of 83 year
5 month and 15 days; what's his birth date.

Thanks, Hugo


Try this:


http://www.j-walk.com/ss/excel/files/xdate.htm

A1 = 2/12/1850
B1 = 83
C1 = 5
D1 = 15

E1 = XDATE(XDATEYEAR(A1)-B1,XDATEMONTH(A1)-C1,XDATEDAY(A1)-D1)