Hiding cell contents

B

Bluehound

I have a spreadsheet with 2 date columns. Column H and column F.

1 column shows the last date an review was made and the other column
shows the date the next review is due.

I am using the following formula in column F to update the next review
date, ie =H1+7, which advances the date in column F by 7 days.

My problem is that I am making new enttries down the columns and when
I try to format column F all the down to save time entering the above
formula, where there are no entries in column H then I get 07/01/1900
in each cell. How can I stop 07/01/1900 being displayed and simply
have a blank cell until I make an entry?

Thanks

(Excel 97 and 2000.)
 
J

JulieD

Hi

you can nest your formula in an IF statement
e.g.
=IF(ISBLANK(H1),"",H1+7)
or
=IF(H1="","",H1+7)

Cheers
JulieD
 
C

CyberTaz

Instead of preformatting & copying to unused rows in the first place, you may
want to use Data>Form to enter new records. It will append new records to the
bottom of the list as well as carry the formatting & formulas down as the
records are added. Just make sure that you have a cell in the Data Range
selected when you go to use the Form.

HTH |:>)
 
B

Bluehound

=?Utf-8?B?Q3liZXJUYXo=?= said:
Instead of preformatting & copying to unused rows in the first place, you may
want to use Data>Form to enter new records. It will append new records to the
bottom of the list as well as carry the formatting & formulas down as the
records are added. Just make sure that you have a cell in the Data Range
selected when you go to use the Form.

HTH |:>)
Click to expand...


Thanks very much for your replies. Yes they both work!!
 
Top