Improve my formula to show past due days

[chrono2483]

Hi everyone,

I tried to self-serve, and find the answer to this, but unable.

Current state: I use a formula, that compares current date with due date, to show me how many days remaining to complete a task.
Problem: Some tasks end up being past due, but the lowest it goes is 0 days
Desired State: I want to be able to show how many days (i.e. negative value) it is, still comparing current date with due date. Example: Today = May 27, 2020, Due Date = May 25, 2020, Days Remaining = -2
Bonus Desired State: Same as above, but stops calculating based off on a value in another cell. Example: If cell = Complete, formula locks in the Days Remaining for that day.

My current formula: =iferror(if(D25-today()<0,0,D25-TODAY()),"")


Any help or direction would be awesome.

Thank you!

 

[Fluff]

How about
=if(D25="","",D25-TODAY()

Not sure you can do the bonus without VBA, or iterative calculation.

 

[chrono2483]

Thank you @Fluff . Tested and works great.

How about
=if(D25="","",D25-TODAY()

Not sure you can do the bonus without VBA, or iterative calculation.

 

[Fluff]

You're welcome & thanks for the feedback.