View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

=if(isblank(a1),"",a1+14)
************
Anne Troy
www.OfficeArticles.com

"Xzilla" wrote in message
...
I have created a worksheet for the purpose of date tracking. The problem
that I have is that 1/14/1900 is displayed after I create a formula.
Example; the formula is a2=a1+14. When there is no date listed in a1
1/14/1900 is displayed. I do not want to see this. When I tried to hide
this, I was unable to see anything. Is it possible to hide this
particular
problem?

Thanks in advance for any help with this matter.