Calculating days left till deadline

Hi ALL

I'm trying to create an action plan and i'm looking for a formula that could let me know how many days are left till the deadline date, taking today's date into account.

This also links to the action status, so if the action is met and ticked off then the status is changed. - I have attached an example which would better explain my point.

Many thanks!

I think you could also use the NOW() function as above, if you wanted it to be more precise.

Daddylonglegs may correct me on this.

The NOW() function returns date AND actual time. this may give a false result in certain cases. TODAY() is the way to go

Thanks daddylonglegs,

Formula works, however i'm sure a simply and, if formula could be used to the action status. - so if days left till deadline is less than 0 and/or action achived check box is not true then 'failed' should be displayed however if the action is checked regardless how many days are left till deadline then status should be 'achieved'.

I just can't seem to get it to work!

Thanks!!!

I can get the formula to work now, but would it be possible to stop counting the days once action is achieve?

Many thanks.