Formulas that links to another worksheet
Posted by Krissy on January 08, 2002 9:59 AM
I am using a formula to pull dates from another worksheet. If there isn't a date in the first worksheet, the formula puts 01/00/00 into the cell of the second worksheet. Is there anything I can do to stop this?
Posted by Dan on January 08, 2002 10:13 AM
Use an if statement to check to make sure the value isn't blank:
=IF([name.xls]Sheet1!$W$6<>"",[name.xls]Sheet1!$W$6,"")
HTH
