Calculate years between two dates more precisely
 

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

Calculate years between two dates more precisely
 

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

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

Regards

Geoff


"Jørn Johansen" wrote in message
...
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

Calculate years between two dates more precisely
 

On Thu, 30 Oct 2003 21:56:04 +0100, "Jørn Johansen" wrote:

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

Calculate years between two dates more precisely
 

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



"GB" skrev i melding
...
=DATEDIF("02/01/2001","01/01/2003","y")

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

Regards

Geoff


"Jørn Johansen" wrote in message
...
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

Calculate years between two dates more precisely
 

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

http://google.com/groups?threadm=865...o-nntp.eunet.n
o

(Watch linewrap - the URL ends in .no)


In article ,
"Jørn Johansen" wrote:

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