View Single Post
  #1   Report Post  
Michael Gillie
 
Posts: n/a
Default How do I stop Excel from treating blank cells as zero?

I'm calculating the difference between two dates, such as

A1 - 1st September
B1 - 10th September

So B1-A1 returns 9, which is great.

But I only enter the dates in column B when a certain visit has been made,
and while the cells in B are blank, Excel treats them as zero (or 1st Januray
1900). So B1-A1 returns -39000 odd.

Is there a way to essentially stop it from calculating the formula until
both cells have a value entered?