Default display of sample date in linked workbook with blank date in source cell

[Barbara Martens]

Destination workbook contains a date column, with values
linked from a date column in a source workbook. The source
workbook may contain blanks in the date column. When a
blank occurs, the destination workbook displays Excels
default date of 1/0/00. I've tried conditional formatting
within the destination workbook to no avail. Does anyone
know how I can display a blank in the date cell of the
destination directory (retaining the link as the date
column will eventually be filled in)?

Thanks!

 

[Frank Kabel]

Hi
try changing the formula to something like
=IF('[otherbook]sheet1'!A1<>"",'[otherbook]sheet1'!A1,"")

 

[Barbara]

Thanks so very much! It works beautifully.

-----Original Message-----
Hi
try changing the formula to something like
=IF('[otherbook]sheet1'!A1<>"",'[otherbook]sheet1'!A1,"")

--
Regards
Frank Kabel
Frankfurt, Germany

Destination workbook contains a date column, with values
linked from a date column in a source workbook. The source
workbook may contain blanks in the date column. When a
blank occurs, the destination workbook displays Excels
default date of 1/0/00. I've tried conditional formatting
within the destination workbook to no avail. Does anyone
know how I can display a blank in the date cell of the
destination directory (retaining the link as the date
column will eventually be filled in)?

Thanks!

.