Try it like this...

=IF(A1="","",A1+7)

--
Biff
Microsoft Excel MVP


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