if statement help

[rentonhighlands]

I am working to take a date and subtract the date I submitted the order to find the amount of days
I would like to write a statement that says if the box is blank and I subtract a date in the past I want the result to be blank.

Can I do this?

 

[Scott Huish]

I think, basically you just need to check if there are 2 dates there. Assuming dates in A1 and B1:

=IF(COUNT(A1:B1)=2,B1-A1,"")