Hi,
do
=if(B1=0,0,A1-B1)
hope this help

"ohnesorge" wrote:

I might not have explained correctly, sry for that If A1=12/10/08, and i
input a compltetion date B1=12/11/08= my answer in C1= (1) which is correct.
My Question is that how do i make C1 display ZERO instead of 39796. if i do
not enter a number into B1, C1 comes up 39,796 which is a problem when i am
trying to add the total amount of days we are behind or on schedule.