I've got a very simple formula to calculate the number of days between two dates which works, with one exception.

Formula:

```
=IF(ISBLANK([Completed Date]),"TBC",[Completed Date]-[Created Date])

```

When the 'Completed Date' value is empty I don't get 'TBC', instead SharePoint displays: `#VALUE!`

Can someone please point me in the right direction?