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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Thanks for your help, at first I didn't recognize that the A1 represented the
from cell

Jack in California
 
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:
 
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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking sheets how do I display the zeros (0) as blank cells 1
Link cell between WS w/o dest display 0-jan if no entry at source 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Average by Date 24
Dates linked in Excel files 3
when setting a cell to equal a blank cell it displays 0 2
Linked cells - why '0' when blank? 3
use month in cell date to sum all relevant cells 2

Back
Top