Count Down

[apmitch]

Hello All, I am a new member, love excel but very "green" can anybody give me a formula which shows "Days" count down. I am building a Gnatt Chart which I am tracking my progress on completing certain task and I want to show "days Count Down" to when I am expected to finish my project.

 

[Hui]

It will be a formula like

=B10-today()

where B10 has the expected completion date

Make sure where you put the formula is Comma formatted as it may default to a date format

 

[apmitch]

Thankyou very much, always looks easier afterwards, much appreciated.