How to link a cell in date format without displaying it as 0-Jan?

J

Jack Miller

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!
 
J

Jack Miller

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

Jack in California
 
J

Jack Miller

Biff:

Additional help please. The IF formula you provided is just what I needed
for a cell to cell within the same worksheet situation, works great!
I'm having difficulty figuring out the correct sentex for the same
situation, only wanting to go from 1)worksheet to worksheet within the same
workbook or 2)workbook to workbook. Would you mind writing out the fomula for
me using the following information?

1)
File name: LinkProblem.xls
Worksheet name with the FROM cell: FROM
Cell location: D4

Worksheet name with the TO cell: TO
Cell location: B4

2) In situation number two as discribed above, all information same except:

From workbook name: LinkProblem.xls
To workbook name LinkProblem2.xls


I hope this isn't too much troble or bother for you, I sincerely appreciate
your assistance.

Jack in California


From:
 
B

Biff

All you have to do is open the linked file and use your mouse (pointing
device) to point to the cell references and let Excel put the path in for
you. For example:

Start typing the formula:

=IF(

Then use the mouse to select the file, navigate to the sheet and select the
cell. Excel will put in the path for you. It's a lot easier than typing it
in yourself especially if you have the typical ridiculously long path.

Biff
 
J

Jack Miller

Thanks again,
I'll try it in the AM.

Jack

Biff said:
All you have to do is open the linked file and use your mouse (pointing
device) to point to the cell references and let Excel put the path in for
you. For example:

Start typing the formula:

=IF(

Then use the mouse to select the file, navigate to the sheet and select the
cell. Excel will put in the path for you. It's a lot easier than typing it
in yourself especially if you have the typical ridiculously long path.

Biff
Click to expand...
 
Top