One way...

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

--
Biff
Microsoft Excel MVP


"Kay" wrote in message
...
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