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

  • Thread starter Thread starter Barbara Martens
  • Start date Start date
B

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!
 
Hi
try changing the formula to something like
=IF('[otherbook]sheet1'!A1<>"",'[otherbook]sheet1'!A1,"")
 
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


Barbara said:
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!
Click to expand...
.
Click to expand...
 
Back
Top