Previous Topic Next Topic

How to calculate number of years between date

Closed
Mike - May 3, 2012 at 11:40 AM
aquarelle Posts 7435 Status Moderator - 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 response

Answer 1 / 1
aquarelle Posts 7435 Status Moderator 491
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
calculating fuel surcharge
Nancy -
xpcman -

1 response
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS
peterappiahkubi -
Wofanat -

2 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses