HOW TO CALCULATE THE NUMBER OF YEARS BETWEEN TWO DATES

[RAMON]

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

[duane]

you will get very close by

=(date2-date1)/365

you could round this as required

[Ragdyer]

=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" <[email protected]> wrote in message
news:[email protected]...
> I WANT TO CALCULATE THE #S OF YEARS BETWEEN TWO DATES

[Gord Dibben]

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" <[email protected]>
wrote:

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