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
|