Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Location
    Michigan, USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating Pre-1900 Dates

    As a genealogist, I would like to be able to use Excel to calculate ages of people born/married/died in the 1600s, 1700s and 1800s.

    Also, sorting columns including dates in those centuries does not even appear to be an option unless I break post-1900 dates into three mo/da/yr columns and then manually enter pre-1900 dates in the three columns.

    Any suggestions? Thanks!
    ~Carol in Detroit

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Calculating Pre-1900 Dates

    There are some downloads available at <A target="_blank" HREF=http://search.atomz.com/search/?sp-q=1900&sp-a=000336ae-sp00000000>The Spradsheet page</A> which should help you.

    Andrew

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating Pre-1900 Dates

    John Walkenbach has this download for handling dates prior to 1900 on his site:
    <A target="_blank" HREF=http://www.j-walk.com/ss/excel/files/xdate.exe>http://www.j-walk.com/ss/excel/files/xdate.exe</A>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •