View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jack Miller Jack Miller is offline
external usenet poster
 
Posts: 5
Default How to link a cell in date format without displaying it as 0-Jan?

Linking from one cell to any other. The from and to cell's are formatted by
date. If the from cell is blank, the to cell will automatically display 0-Jan
(or any form of January 0000). I need the to cell to remain blank if the from
cell is blank. Please help!