Calculating age from DOB and DOD

  • Thread starter Thread starter John Nall
  • Start date Start date
J

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.
 
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 **
 
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.
..
 
Back
Top