Calculate years between two dates more precisely

Jørn Johansen · Oct 30, 2003

How do I set up a formula so I would get this answer:

01.01.2003 - 02.01.2001 = 1 year (not 2 because of the second date)

Jørn Johansen

GB · Oct 30, 2003

=DATEDIF("02/01/2001","01/01/2003","y")

Further details are here:
http://www.cpearson.com/excel/datedif.htm

Regards

Geoff

Ron Rosenfeld · Oct 30, 2003

How do I set up a formula so I would get this answer:

01.01.2003 - 02.01.2001 = 1 year (not 2 because of the second date)

Jørn Johansen

Look at the undocumented DATEDIFF function:

=DATEDIF("2/1/2001","1/1/2003","y") --> 1

See http://www.cpearson.com/excel.htm

--ron

Jørn Johansen · Oct 31, 2003

Thanks. I have tried, but it does not give an answer at all! I use Excel
2002, norwegian language.

J.E. McGimpsey · Oct 31, 2003

Here's a macro by Harald Staff which might help you translate:

http://google.com/[email protected]
o

(Watch linewrap - the URL ends in .no)