Upload the workbook you're using if you can't map your Date due to the A1 cell and the Date Paid to B1 that I used in the formula.

It doesn't matter where you put the formula as long as you use the correct cell references in the formula

i.e. is your G4 the Date paid (or blank) and B4 the date due?