I WANT TO CALCULATE THE #S OF YEARS BETWEEN TWO DATES
R Ragdyer Feb 21, 2005 #2 =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
=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
G Gord Dibben Feb 21, 2005 #3 Ramon With earliest date in A1 and later date in B1 In C1 enter =DATEDIF(A1,B1,"y") & " years" Gord Dibben Excel MVP
Ramon With earliest date in A1 and later date in B1 In C1 enter =DATEDIF(A1,B1,"y") & " years" Gord Dibben Excel MVP