Calculating age from date of Birth to Date of Death

[Rossjp]

The formula below as well as other recommended methods yields the [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=VALUE]#VALUE [/URL] ! error. see following note. Cells are formatted identical to the the formula that is noted to work.

A 1/26/1875
B 7/21/1881
C [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=VALUE]#VALUE [/URL] !

The formula the yields [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=VALUE]#VALUE [/URL] ! is =ROUNDDOWN((E18-E19)/365.25,0) this formula returns a proper age in the same sheet with the only difference being that the dates are in1900s and 2000s

Would someone please help me figure this out?

Thanks

 

[mrshl9898]

Are the dates numeric? =ISNUMBER(A1) should return a TRUE if they are

 

[mrshl9898]

Excel dates start at 01/01/1900. They won't be numeric.... You'll need to use a different calculation, turning parts of the dates to numbers.

 

[Rossjp]

Thanks! I had no idea that this would be so difficult. I just saw and ungodly looking VBA that claims the do it but I'm not well versed enough to figure out how to apply it..

 

[Rossjp]

No! Don't know how to turn a date into a number.

 

[mrshl9898]

Here's a rather lengthy solution with formulas.


http://www.excelformeln.de/formeln.html?welcher=1

Just needs google translate.

You'll just need to convert months and days to a decimal and add them to the years.