Forum Discussion
KGGolds146
Aug 29, 2023Copper Contributor
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?
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.