Let's say your formula is B1-A1. You want this to display nothing until there
values in both cells. Use this formula: =IF(COUNT(A1:B1)=2, B1-A1,"") where
"" are two double quotes with nothing inside them. Id the two cells are not
side-by-sise use something like =IF(COUNT(S4, V4)=2,V4-S4,"")
best wishes
--
www.stfx.ca/people/bliengme


"native earthling" wrote:

I have two columns of dates; one for "initial input" and one for "work
started." I have a third column to show the difference of days between
dates. In this column I want it to remain blank until there is a date in
both of the previously mentioned columns. Right now I am getting a number in
the third column as soon as an "initial input" date is entered. How can I
prevent that from occurring?