J JE McGimpsey Jan 9, 2005 #2 One way: =DATEDIF(A1,TODAY(),"y") See http://cpearson.com/excel/datedif.htm
G Guest Jan 9, 2005 #3 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 Click to expand... Now what?
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 Click to expand... Now what?
M Max Jan 10, 2005 #4 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
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
