Do an isblank formula. Where Date1 is where you want to show the linked
values and Date2 is your source, type in Date1 sheet:

=IF(ISBLANK(Date2!A1),"",Date2!A1)

"JayDee" wrote:

Microsoft Excel 2007: If there are cells in the original worksheet (file)
that contain dates and other cells that are "date" formatted; however, no
dates have been entered, how can I show a "blank" cell on the worksheet of
the linked file? Currently, if the date formatted cell is blank on the
original file, the second file is auto filled with the date of 1/10/1900. I
need the linked worksheet to show blank cells until an actual date is entered
in the cells of the original file.