View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelinSD excelinSD is offline
external usenet poster
 
Posts: 1
Default How to get a linked workbook to return a blank value?

I have linked 2 workbooks and one of the columns liked is a date format. How
do I get the linked work book to return a blank if there is not a date typed
into the master workbook.
My formula is below:
='[PROPOSAL LOG.xls]Tracking Log'!$G71
What it gives for blanks:
01/00/00