I have been asked to set up an Excel chart for our local cemetery as a free favor for a friend.
A lot of the stones have a date died but no date born but they do have the
years, months, days lived.
Can something be set up to work a date backwards?
Example - Died - 7-10-1879 (this could also go from 1700 to 1800 or 1800 to 1900 or 1900 to 2000)
Lived 23 Y, 4 M, 1 D
This would work back to (I think) 3-9-1853 date of birth.
We will have two Excel sheets, one with the plot layout (I am doing stone by stone location)
and the other one
being a register having the last & first name, Date born (this the part I don't have when they just have the lived data on the stone) and I need your help with., Date died and any other data that was on the stone.
Thank you for your help.
A lot of the stones have a date died but no date born but they do have the
years, months, days lived.
Can something be set up to work a date backwards?
Example - Died - 7-10-1879 (this could also go from 1700 to 1800 or 1800 to 1900 or 1900 to 2000)
Lived 23 Y, 4 M, 1 D
This would work back to (I think) 3-9-1853 date of birth.
We will have two Excel sheets, one with the plot layout (I am doing stone by stone location)
and the other one
being a register having the last & first name, Date born (this the part I don't have when they just have the lived data on the stone) and I need your help with., Date died and any other data that was on the stone.
Thank you for your help.