Rayrichard
New Member
- Joined
- Jan 20, 2014
- Messages
- 4
Hi all
I am working on my family tree and thought I would create a spreadsheet that automatically updates the ages of all protagonists when the user opens the document. I have managed to achieve this successfully using the following formula:
=INT((H2-A2)/365)
The only issue I have is that the formula does not work for people born in the 1800 as you can see in the above image.
I have tried a number of other formulas with no success as yet.
I was hoping that there is a brain box out there who can solve this mystery for me or point me in the right direction.
Many thanks
Richard
I am working on my family tree and thought I would create a spreadsheet that automatically updates the ages of all protagonists when the user opens the document. I have managed to achieve this successfully using the following formula:
=INT((H2-A2)/365)
The only issue I have is that the formula does not work for people born in the 1800 as you can see in the above image.
I have tried a number of other formulas with no success as yet.
I was hoping that there is a brain box out there who can solve this mystery for me or point me in the right direction.
Many thanks
Richard