Calculate years between two dates more precisely

[Jørn Johansen]

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]

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

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

Regards

Geoff

 

[Ron Rosenfeld]

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]

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

 

[J.E. McGimpsey]

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)