Nov 29 2020 04:27 AM
Nov 29 2020 04:41 AM
Example in the file
I would be happy to know if I could help.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Nov 29 2020 05:02 AM
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.