Datedif countdown, cant show negative

[KGGolds146]

I have a small worksheet that I want to use to use to identify when jobs are due to complete.

At the moment I can identify how many days to completion and the due date, however as soon as the date becomes overdue I lose the information.

Any suggestions?

[#2]

@KGGolds146 

If you want to count days, you don't need DATEDIF. You can use a formula such as

=due_date-TODAY()

and format the cell with the formula as General.