IF(AND Statements

[JRose0303]

I have input the following IF(AND statement, =IF(AND(H4<G2,J4=0),"Past Due"," "); however, I cannot seem to get the cell to remain blank when H3 has not been populated (it stays Past Due).

H4 = a date field to be populated as an end date of an authorization

G2 = Today's Date

J4 = a date field to be populated as a authorization extension date

I4 = formulated cell - This cell I want to remain blank when H3 has not been populated and to only populate as "Past Due" when H3 is less than today's date (G2) and J3 has not been populated; otherwise, stay blank (" ").

When H4 is populated, everything works fine; it's when there's nothing there that I'm running into the issue.

I've attached a picture view of what I'm working on as a visual.

Excel Forum Pic.JPG

Thank you so much for your help with this!