subtracting dates leaves date/number or date
that was the question. Is the answer before me? How do I set the forula cell
od D7 to stay blank until an actual date is in D6
D7 =d6-d5 d5 is empty most of the time. I would like D& to stay emty also,
but hold the formula.
Is it there?
Did I miss it?
Thanks
"Mark" wrote:
Across the columns there are projected dates in row C5
C6 is empty, but "will" contain Actual dates
C7 is =C6-C5 formatted to number
My problem or question is without and "Actual" date in C6
I get a "numerical date" in C7 ,
because it is calculating C6 against C5.
thus rendering C7 with a numerical value of C5.
Is it possible to have C7 (with the formula)stay blank or white until and
actual date is placed in C6?
Thank you once, again, and for the numerous helps today.
Mark
|