link a date between two worksheets.
 

I am trying to link a date from one wooksheet to another, using the same
workbook. For the cells in workbook A that are blank, I want them to show up
on workbook B as blank. However, when I try to link the blank cell in A, I am
getting a date format (1/1/00) in cell B. Any ideas? Thanks!

link a date between two worksheets.
 

=if(a1="","",a1)

=if(sheet2!a1="","",sheet2!a1)



Caterpillar wrote:

I am trying to link a date from one wooksheet to another, using the same
workbook. For the cells in workbook A that are blank, I want them to show up
on workbook B as blank. However, when I try to link the blank cell in A, I am
getting a date format (1/1/00) in cell B. Any ideas? Thanks!

--

Dave Peterson