How to calculate number of years between date

Closed
Mike - May 3, 2012 at 11:40 AM
aquarelle
Posts
7099
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
January 20, 2022
- May 3, 2012 at 01:09 PM
Hello,

How do you calculate days or years between 2 dates that are in different centuries. Example: birth 4/16/1891 and death 5/23/1924?

1 reply

aquarelle
Posts
7099
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
January 20, 2022
490
May 3, 2012 at 01:09 PM
Hi,

Excel can not work with dates prior to the year 1900, but you can find a macro that permit it here :
http://j-walk.com/ss/excel/files/xdate.htm

Best regards
0