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