View Single Post
  #1   Report Post  
Dorian74 Dorian74 is offline
Junior Member
 
Posts: 10
Default error message "#VALUE!" due to blank cells

Hi All,

I am trying to have a spreadsheet where i check the delivery time on orders (attached a picture).
Essentially, it calculates the difference between the "Promised Date (A1)" and the "Atual Date (A2)" i.e. A1-A2
The problem is where is have blank cells with no information yet. then i get the nice error message "#VALUE!"

Can anyone help in having these cells show nothing instead of the error message?

Thank you!
Attached Images