JE...
I would like to present a blank cell in "L46" if there is no Anniversary
date entered in "D46"
different examples;

D46: Anniversary Date ... MM/dd/yy
H46: =IF(D46="","",DATEDIF(D46,TODAY(),"Y"))
L46: =SUM(N5:N19)/H46

Now what?

"JE McGimpsey" wrote:

One way:

=DATEDIF(A1,TODAY(),"y")


See

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

In article ,
"Kane" wrote:

How would I determine years of service.... example is September 01, 1989?