Apr 14 2022 06:52 AM
DATEDIF does not calculate age before 1900.
Is there a work around?
Roy
Apr 14 2022 07:01 AM
Excel does not work with dates before 1900. You could add (for example) 400 years to both dates.
So for example
Apr 14 2022 08:03 AM
Apr 14 2022 08:50 AM
You could use a custom VBA function:
Function Age(d1, d2) As Double
Age = (CDate(d2) - CDate(d1)) / 365.2422
End Function
Use like this:
=AGE(D2,E2)
where D2 is date of birth, E2 is date of death.
Apr 14 2022 09:04 AM
As @Hans Vogelaar mentioned Excel calendar starts from 1900 if your are on Windows and from 1904 on Mac. For previous dates you need a workaround, otherwise they are not recognized. We have what we have.
Alternatively you may use VBA or Power Query, they work from year 100. If you have any persons before that we still need some workaround.
Apr 14 2022 09:40 AM
In addition to the example of Mr. @Hans Vogelaar here with VBA
How to calculate ages before 1/1/1900 in Excel
...although the simplest and faster solution proposed by Mr. @Hans Vogelaar.
I know I don't know anything (Socrates)