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