How to hide #UNPARSEABLE error

Hey All,

I have this formula =NETDAYS(Created16, [Due Date]16) and it's working just fine. It's just give me the number days left between two dates.

But, when the data cells don't have values, it gives me this error "#UNPARSEABLE".

I'm guessing I need to use an "IF" statment to eliminate this error, but I don't know how to do that and I was hoping maybe one of you could help me.

Thanks.

Ben.

Find more posts tagged with

Formulas

IT & Operations

Comments

J. Craig Williams

Try IFERROR()

https://help.smartsheet.com/articles/775363-using-formulas#iferror

Craig

Bertus Ligthelm

Hi Ben,

Further to Craig's reply, I normally use empty quotation marks as specified content in the event of an error if I want the cell to display as being empty:

=IFERROR(NETDAYS(Created16, [Due Date]16),"")

Hope this is useful.

Bertus