Dates

[niting]

Hi Forum,


I used a formula which was like if((date in $a$3-date in a2)>366, 28,0) and copied it across the range


However, even with cells which had to be subtracted, being blank, the formula produced the result, implying it took the blank cells as some date.


Could you explain why it is so??


Thanks

Nitin

 

[vijaySharma]

Blank were considered as ZERO... if you evaluate your formula you will see that..


~Vijay

 

[Luke M]

Possible fix:

=IF(COUNT($A$3,A2),"",IF($A$3-A2>366,28,0))