Date backward question

[DDH]

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.

 

[Michael M]

my pleasure....thanks for the feedback...

 

[barry houdini]

FWIW you can do this without any add-ins, e.g. with this formula in B2

=TEXT(EDATE(LEFT(C2,LEN(C2)-4)&RIGHT(C2,4)+400,-D2*12-E2)-F2,"m/d/")&YEAR(EDATE(LEFT(C2,LEN(C2)-4)&RIGHT(C2,4)+400,-D2*12-E2)-F2)-400

 

[DDH]

barry houdini - Thank you for your reply.

Thank you for the formula, I will use it also.
I am very happy that I learned how to do Add-In's.

Thank you very much for your help.

 

[Michael M]

Barry
That's very clever....very nice ....ray:

 

[DDH]

barry houdini - I have been trying to understand your formula.

You take c2 and use 9-8 and put the 1890 togeather with it then add 400 ???
and then minus 80 times 12 minus 29 and then I get lost.

Like Michael M said your are very clever and smart and a Excel professional.

Thank you