=IF(COUNT(C10,C5)=2,C5-C10,0)

OR

=IF(C10,C5-C10,0)


If this post helps click Yes
---------------
Jacob Skaria


"Kay" wrote:

I have the following formula in Cell H4
= cell C5 (which is the end date) minus cell C10 (which is the start date) I
want to add another formula in Cell H4 to make it = 0 if Cell C10 is empty.

Thank you.
--
KK