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.

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.

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

HTH
Kostis Vezerides

On Jun 27, 7:04 pm, JayDee <Jay...@discussions.microsoft.com> 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.

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

On Jun 27, 5:04*pm, JayDee <Jay...@discussions.microsoft.com> 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.