Hiding dates

B

Bryan

Hi,

I have created a workbook which has a number of fields in worksheet one.
When data is keyed into this sheet the two other sheets in the workbook are
populated.

One of the sections requires dates to be put in.
When no date is entered the other sheets default to "00/01/1900". is there
a way of keeping these cells blank until a date is entered in the first sheet?

Thanks,
bryan
 
G

Guest

Hi

The usual way is to use something like this:
=IF(Sheet1!B9>0,Sheet1!B9,"")

Hope this helps.

Andy.
 
B

Bob Phillips

Are you using formula to populate the other sheet? If so, test the value
first,,like this

=IF(Sheet1!A1="","",Sheet1!A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bryan

Thanks Andy/Bob - Problem solved!

Cheers,
Bryan

Andy said:
Hi

The usual way is to use something like this:
=IF(Sheet1!B9>0,Sheet1!B9,"")

Hope this helps.

Andy.
Click to expand...
 
Top