I cant work out what the error is.

[ss]

In this formula =IF(D12=0,"",D12 -C12+1) I get a return of 28 which
is correct.

In this formula =IF(D11=0,"",D11 -C11+1) I get #VALUE!

I cant understand this, I have checked cell format and both are in
general, I have tried dragging down and still no change. The subtraction
elemenst are 2 dates.

 

[Dave Peterson]

You'll see this error if
D11 is non-empty and non-numeric
or
C11 is non-empty and non-numeric

 

[Stan Brown]

In this formula =IF(D11=0,"",D11 -C11+1) I get #VALUE!

Either C11 or D11 has a #VALUE in it.

 

[ss]

Either C11 or D11 has a #VALUE in it.

Now sorted I dragged down the cells above (same format) and it sorted
the problem although I still never worked out what the prob was.