Count down in days formula

Eric Tinney

I need help finding the right formula. I have basic Gantt with four phases, each phase has tasks associated with it as well as durations. I've set a "start date" column and by using durations for each task and predecessors I then have the calculated "finish date" column for each tasks and each phase.

 

I need to create a third date column and set it up as a count down in days. So at any point if a team member looks at the gantt they'll know that there are "X" amount of days left in the phase or overall project. 

 

I created a 'Days Remaining" column and in the top cell not included in a phase or task Iinserted the formula for todays dated =TODAY(). After this I'm lost.

J. Craig Williams

=Finish23 - TODAY()

 

for row 23.

 

Hope this helps.

 

Craig

 

Eric Tinney

Thanks Craig,

Works like a charm.

Eric

Kal-El

What about working days remaining only?