How to show days overdue only when task hasnt been completed

[careygorgees]

So let me describe my sheet:

Column G = Deadline
Column H = Days Left to Complete
Column I = Days Overdue
Column J = Date Completed

I want to show the number of days overdue BUT only when the task is actually overdue (i.e i dont want it saying -2) AND i dont want it to show anything if the column G is blank.

So far i have managed to produce this formula which works for Days left to complete: =IF(AND(G8>TODAY(), J8=""),G8-TODAY(), "")

I have tried using this formula for days overdue but it just doesnt seem to be working how i want it too: =IF(OR(G8>TODAY(), AND(G8="", J8="")), "", G8-TODAY())

Any help would be greatly appreciated.