EARLY date calculating formulas?

[Robert E. Carneal]

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).]

[Tom Hanlin]

Search the forums for "julian" for all kinds of help (and code).

Leap years probably aren't the key concern, here. The calendar system
was far from unified back then-- your results could be off by months,
unless you have location information as well as the dates, and good
charts describing the date offsets between various locations-- or if
you know that the person was born and died in the same place, and
there were no calendar reforms in that area during his lifetime.


------------------
Tom Hanlin
PowerBASIC Staff

[Matthew Berg]

That information is available in The Calendar FAQ, specifically the section "When did country X change from the Julian to the Gregorian calendar?"