Dates linked in Excel files

[JayDee]

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.

 

[Storm]

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)

 

[vezerid]

=IF('other sheet'!A2="","",'other sheet'!A2)

HTH
Kostis Vezerides

 

[Pete_UK]

You could do it like this:

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

will display a blank if the "sending" cell is blank.

Hope this helps.

Pete