Time served

[jee22]

Dear all

If I calculate by hand the number of years between two dates, say 30 May
1989 and 4 November 2003 I get 15.4360.

If I use Excel =(date2-date1)/365 I get 15.4438.

I know excel uses date and time and that this is probably the reason for the
error but if you use excel to calculate pension payments then the error is
significant.

does anyone have a solution please


Thanks

--


_____________________________________________
_____________________________________________
Mr J E Ellis
University of Cambridge
Department of Materials Science & Metallurgy
Pembroke Street
Cambridge
CB2 3QZ
England
Tel + 44-(0) 1223 334346
Fax + 44-(0) 1223 334567
E-mail (e-mail address removed)
_____________________________________________

 

[Arvi Laanemets]

Hi

Something is wrong with your math's - the difference betweent those 2 dates
is 14 years and 158 days.
14+158/365=14.4329
With your second formula
(Date2-Date1)/365=14.4411
The difference is because leap years.

With Excel2000, you can use a DATEDIF function
NumberOfYears=DATEDIF(Date1,Date2,"y")
NumberOf RemainingDays=DATEDIF(Date1,Date2,"yd")