Procedure to Hide a "counter" when Complete

[Heyna]

Hi folks;
I hope I can make this clear enough to actually get help on this...
I've made a Workbook that has one sheet that is an "overview" of jo
schedules. Each worksheet is one "job", with multiple bits o
information, and set due-dates. Since there are several jobs (6, to b
exact), I made the overview page, which shows at-a-glance information
including due dates.
On the "overview sheet", I made a cell (for example, I'm using th
reference sheet "Job #1" as the motivator) that showed the current day
date (ex:cell D27=NOW()), and a due date motivated from the job'
worksheet (ex: ='Job #1'!L11), and a cell that shows how many days ar
left before the project is late {ex
=IF(F27="","",NETWORKDAYS(D27,F27))}.
This works great for a "countdown", but how can I have this cel
"clear" when the work is done, and not late? What I mean is that ther
are multiple jobs on one "overview sheet", and jobs don't all end a
the same time. So, by the time "Job 6" is winding down to it's du
date, "Job 1" will be showing -133 days, or 133 days late, which look
horrible on a progress report. Can anyone think of a way that, when th
job is completed, I could fill in a cell somewhere and have that cel
make that running tally go "blank", show a clear cell? I hope thi
makes sense, let me know if I need to clarify..
Many thanks,
Scot

 

[Frank Kabel]

Hi
how do you show if a work is done?. If you use for example column G
with the word 'done' try
=IF(OR(F27="",G27="done"),"",NETWORKDAYS(D27,F27))}.

 

[Whnke]

Use one cell to prepare the countdown (make the cell hidden by blackin
it out). Say the countdown is in A2: in another cell adjacent to it
put =if(A2>0,A2,"") it will display the countdown until it reaches zer
then it will be blank

 

[Heyna]

Many thanks; this seems sound. Now, if I could take it one step further
since projects CAN go over schedule, I'd like to use this general ide
that's been proposed above, but have a system where I can have folk
who may be monitoring this Worksheet choose whether the job is ove
schedule, or if it is closed out. I'm thinking a validated cell tha
gives the choice of yes or no, and if yes, then the "counter" goe
blank, and if it is no, I'll conditionally format the cell to show th
number as red. Will I need to do a Concancetate formula? Maybe I'
ovethinking this...
Many thanks for the help!!!
Scot