View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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