Hiding cell contents
 

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.)

Hi

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

Cheers
JulieD

"Bluehound" wrote in message
om...
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.)

Instead of preformatting & copying to unused rows in the first place, you may
want to use DataForm 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 |:)

"Bluehound" wrote:

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.)

"?B?Q3liZXJUYXo=?=" wrote in message ...
Instead of preformatting & copying to unused rows in the first place, you may
want to use DataForm 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 |:)

"Bluehound" wrote:

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.)



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