Counting Over due by days

[Bilal]

I am maintaining the excel sheet for correspondences, I would like to have a column where it shows the task overdue by number of days. In attached xl sheet it is as
Column "E" - Start Date
Column "F" - Closing Date
Column "H" - Actual Action / completion date
in Column "I" I want the number of days to be displayed if it was not completed. once the completion date is entered in Column C, this number need not be there.

 

[Hui]

Bilal

Firstly, Welcome to the Chandoo.org Forums

I think you want something like
I3: =IF(C3>0,"",F3-E3)