HOW TO CALCULATE THE NUMBER OF YEARS BETWEEN TWO DATES
 

I WANT TO CALCULATE THE #S OF YEARS BETWEEN TWO DATES

=DATEDIF(B1,A1,"y")

Where A1 is today,
And B1 is a past date.

Check out Chip Pearson's web page on this "Un-Documented" function:
(Except in XL2K)

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RAMON" wrote in message
...
I WANT TO CALCULATE THE #S OF YEARS BETWEEN TWO DATES

Ramon

With earliest date in A1 and later date in B1

In C1 enter =DATEDIF(A1,B1,"y") & " years"


Gord Dibben Excel MVP


On Sun, 20 Feb 2005 16:41:04 -0800, "RAMON"
wrote:

I WANT TO CALCULATE THE #S OF YEARS BETWEEN TWO DATES