Creating conditional formula to calculate how many days past due

[HardWorkingMomma]

I have a spread sheet for our Board of Directors to keep track of deadlines.
In cell G1 is the DUE DATE
In cell H1 is a place to record date accomplished, and will be left blank until accomplished
Cell I1 is where i want a formula to calculate days past due. If the item is not past due yet, because the due date has not passed how can i show a DAYS LEFT TO COMPLETE? (in another cell? or will the formula show a result that indicates days remaining?)


Ideally I assume that if a task in G1 has a due date of 1/1/2015 and the item is completed on 1/10/2015 then that calulation will show that it was completed 9 days past the due date.

Do you have any formulas that i can try?

 

[gaz_chops]

have a look at this
http://www.mrexcel.com/forum/excel-questions/831651-help-countdown-clock-formula.html

 

[HardWorkingMomma]

Those formulas are not working.
Here is what I have
G1=due date
H1=days remaining (I guess a countdown)
I1=Days past Due
J1=Date accomplished (I suppose once this field is filled, it would "stop" the days remaining or past due cells?

 

[gaz_chops]

This is the formula that I linked to! Tweaked to fit (hopefully)
=IF(J2<>"","Completed",IF((G2-NOW())<=0,TEXT(NOW()-G2,0)&" Days Overdue","Due in "&TEXT(G2-NOW(),"dd")&" Days"))

Let me know if it works?