Forum Discussion

KGGolds146's avatar
KGGolds146
Copper Contributor
Aug 29, 2023

Datedif countdown, cant show negative

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?

  • 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.

Resources