How to adjust this formula to keep "Not yet entered" cells blank

How can I adjust this formula to keep not yet entered cells blank? I'm tracking whether or not jobs are complete on time using dates; Due Date [F] and Date Completed [G]. They are currently marked as "YES" if no Due Date is listed

Here is my current formula:

=IF(AND(F2<>"",ISBLANK(G2)),"NOT YET COMPLETED",IF(G2<=F2,"YES",IF(G2>F2,"NO","")))


I started having the issue when I added an "=" sign inside the IF(G2<=F2, "YES", .... I did this in order to make jobs that were completed on their exact due date marked as completed on time.

perhaps it marks them as yes because a blank cell is = to a blank cell?

Obviously, I need it to say YES when entered G2 Data is Equal to entered F2 data. For example when Due Date = Completion Date. Yet I do not want it to say "YES" (completed on time) when there has not even been a due date entered [F2] but I also want to place the formula in the column for future rows so the formula must be adjusted.



How can I adjust my current formula to leave cells blank when there is no [F2], while still following the rule [F2]=[G2]?

nate

Here is my work book

Thanks! Genius solution. I think it works! I'll let you know if through further testing I have issues but it seems solid.