Forum Discussion
datedif for years > 1900
I try to user datediff for people who lived before 1/1/1900; this does not work as excel considers 1/1/1900 as day one. How can I get the result for someone who lived say from 1/3/1600 to 5/5/1665 ??...
Here is How to calculate ages before 1/1/1900 in Excel macro from Microsoft with step by step instruction how to use it.
Other variant is Power Query which natively works with such dates.
And different kind of formulas like NikolinoDE suggested.
You may check pre-1900 dates thread here where above variants are discussing.