Thanks for your help, at first I didn't recognize that the A1 represented the
from cell

Jack in California

"Gord Dibben" wrote:

=IF(A1="","",A1) entered in the target cell.


Gord Dibben MS Excel MVP

On Wed, 1 Nov 2006 13:42:02 -0800, Jack Miller
wrote:

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!