easy date issue

[Emoncada]

I have data pulled from one spreadsheet to another. So when I am pulling a date from one to another if the date is not entered on the first copy it's giving me a Saturday, January 00, 1900. How can I keep it blank.

 

[TheNoocH]

assume your formula is

=Sheet1!A1

you could do this

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

 

[Jon von der Heyden]

Hi,

Change your reference to =IF(ISBLANK(reference),"",reference)

Where reference is the workbook/sheet/cell reference that should contain the date.

Cheers,
Jon

 

[Emoncada]

Thanks a little brain freeze there.