cell contents
 

I need cell B1 to show the same content as A1, which is a cell that holds a
date. Therefore I set the formula for cell B1 as "=A1". The problem is that
if I don't have a date entered in cell A1, B1 shows "1/0/00". Is there a way
for B1 not so show any content unless A1 has content?

cell contents
 

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

--
CCO


"Candace" wrote:

I need cell B1 to show the same content as A1, which is a cell that holds a
date. Therefore I set the formula for cell B1 as "=A1". The problem is that
if I don't have a date entered in cell A1, B1 shows "1/0/00". Is there a way
for B1 not so show any content unless A1 has content?

cell contents
 

=IF(A1<"",A1,"0")

You can put what you want between the last pair of quotes

"Candace" wrote:

I need cell B1 to show the same content as A1, which is a cell that holds a
date. Therefore I set the formula for cell B1 as "=A1". The problem is that
if I don't have a date entered in cell A1, B1 shows "1/0/00". Is there a way
for B1 not so show any content unless A1 has content?