Calculating age from DOB and DOD

[John Nall]

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.

 

[Paul B]

John, for working with dates before 1900 have a look here
http://j-walk.com/ss/excel/files/general.htm at the Extended Date Functions
addin

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[David McRitchie]

Hi John,
Almost the same question as asked recently
See John Walkenbach's Extended Date Functions
http://j-walk.com/ss/excel/files/xdate.htm

I think you should also include two text columns with
the month spelled out like on the tombstone and of course
they would have 4 digit years, just to provide additional
verification.
..