J
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)
_____________________________________________
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)
_____________________________________________