Datedif countdown, cant show negative

Copper Contributor

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?

1 Reply


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




and format the cell with the formula as General.