Sorry, that I left a bit out and it didn't make sense:
The only way I can get it to work is to type =IFERROR(C3," ") in column D and then hide column C and use the results in column D as the "No of Days" . Is there an easier way, ie, can I combine IFERROR with the original formula you sent to me?
|