No announcement yet.

EARLY date calculating formulas?

  • Filter
  • Time
  • Show
Clear All
new posts

  • EARLY date calculating formulas?

    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.


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

  • #2
    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


    • #3
      That information is available in The Calendar FAQ, specifically the section "When did country X change from the Julian to the Gregorian calendar?"
      If you try to make something idiot-proof, someone will invent a better idiot.