I have a work sheet that contains multiple columns, three that contain date
information. The first column(G) is named Date Assigned; the second column(H)
is named Date Completed; the third column(I) is named Days Taken to Complete.
(I) should be net work days. I have used the NETWORKDAY function, but when,
lets say cell H1 is blank because the assignment is not complete, cell I1,
which contains the formula, will return a large negative number. I would
like that cell to remain blank until a date in entered in cell H1. And, if
possible, I would like to have text "days" to appear after the number that
results in cell I1.

Thanks