View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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