Copying date from sheet1 cell to sheet2 cell

[Guest]

I enter a date in sheet1 B2. I want date to appear in sheet2 C3. I used the
formula CELL "contents" in C3. It works except when cell B2 is blank,
01/00/00 appears in C3. I want C3 to be blank also. I have both cells
formatted to Date.

 

[Dave Peterson]

You could use:
=sheet1!b2
instead of =cells("contents",sheet1!b2)

But to make the cell look empty:

=if(sheet1!b2="","",sheet1!b2)