I need to calculate a person's age given their birthdate and death date. My wife gave me a this formula =SUM(G2-F2)/365.25 with "G" being date of death and "F"beinig date of birth, which works great for the 1900s and 2000s. But for a brithdate in the late 1800s it cannot calculate the age. This would seem to be a problem with the date function in Excel. Any ideas on how to get it to calculate with dates in the 1800s?
This may be insightful.
http://www.exceluser.com/explore/earlydates.htm
And here is a macro on the Microsoft Support site that specifically deals with age calculations prior to 1900.
http://support.microsoft.com/kb/245104
Last edited by Whizbang; 10-11-2011 at 02:05 PM.
Just an FYI here is another.
http://j-walk.com/ss/excel/files/xdate.htm
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
To Excel, the world started in 1900. In VBA, dates go back to 100AD.
So you could use a simple UDF:
E.g.,
Please Login or Register to view this content.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Try this formula
=DATEDIF(IF(ISNUMBER(F2),EDATE(F2,400*12),(LEFT(F2,LEN(F2)-4)&RIGHT(F2,4)+400)+0),EDATE(G2,400*12),"y")
This should work for DOBs before 1900
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks