Help - Keeps returning Date?

[watson150]

Hi All,

I have a column, lets say Column A which has a formula running down which is just to equal what is in another columns cell on another worksheet. i.e. A1 returns Sheet1 A1, A2 returns Sheet1 A2 and so on

These contain dates. But when there is no date and the cell is blank, it returns 0/01/1900. How can I have it return blank, but still return a date when a date is entered?

The return of 0/01/1900 messes with another formula I have in another column is all

[sandy666]

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

you can combine a few criteria:
=IF(OR(ISBLANK(Sheet1!A1),Sheet1!A1="",Sheet1!A1=0),"",Sheet1!A1)