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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Kane" wrote in message
...
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?