Awesome Thanks.

How would this work if I am using NETWORKDAYS in cell C3? Formula

=NETWORKDAYS(A2,A3)-1

Is it the same formula to leave cell C3 blank until the data is entered into
Cells A2 and A3?

Thankyou again.

"FSt1" wrote:

hi
=if(A2="","",A2+7)
or
if a2 is blank then blank else a2+7
the formula will show in the formula bar but the cell on the sheet will be
blank.

regards
FSt1

"SarahN" wrote:

Hi,

I am creating a worksheet that will be completed by a number of people.

I have a date formula


A B C
1 10/02/2010 =A1+7 (17/02/2010)
2 Blank =A2+7 (07/01/1900)

Is there any way to make Cell C2 remain blank until the information in cel
A2 is entered.

I enter a number of furmulas into cells where there is no information being
entered yet as it is a blank worksheet, is there a common way to have the
cells remain empty until the data cells have information in them?

I hope I have not confused anyone.

Thanks for your help in advance