I need some formulas if anyone has them please. This is for a
genealogy project, and I am missing dates.
For quite a few people, I will have the dates/he died and how
long they lived in Y years, M months, and D days. Example:
Died January 1, 1771. Lived 5 months and 11 days.
OR
I have the opposite as well. It will give a birth date, and no
death date, but will say s/he lived Y years, M months, and
D days. Example:
Born February 13, 1689, lived 22 years, 7 months, 27 days.
I guess I am looking for two formulas, one that calculates
backwards and one calculating forwards. Can anyone share that
with me please?
Yes, I am aware of the leap year problems, and not sure how to
handle that.
Thank you very much.
------------------
[This message has been edited by Robert Carneal (edited October 31, 2001).]
genealogy project, and I am missing dates.
For quite a few people, I will have the dates/he died and how
long they lived in Y years, M months, and D days. Example:
Died January 1, 1771. Lived 5 months and 11 days.
OR
I have the opposite as well. It will give a birth date, and no
death date, but will say s/he lived Y years, M months, and
D days. Example:
Born February 13, 1689, lived 22 years, 7 months, 27 days.
I guess I am looking for two formulas, one that calculates
backwards and one calculating forwards. Can anyone share that
with me please?
Yes, I am aware of the leap year problems, and not sure how to
handle that.
Thank you very much.
------------------
[This message has been edited by Robert Carneal (edited October 31, 2001).]
Comment