Years of service...

[Guest]

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

 

[JE McGimpsey]

One way:

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


See

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

 

[Guest]

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?

 

[Max]

Think you could try in L46:

=IF(OR(H46="",SUM(N5:N19)=0),"",SUM(N5:N19)/H46)

The above will return a blank in L46
if either: H46 ="", or SUM(N5:N19)=0