Compair two Dates to if they are the same.

[staticpony]

Hi
I have the current date in column A1:a7, ( Automatically populated when excel sheet opens by vba.)
In column C1:C7 I have invoice Value Manual entered.
In column E1:E7 I have invoice due date Manual entered.
In column G1:G7 I want invoice Value entered when invoice date equals the current date.
In column I1:I7 I want the payment date to be entered and not to change when column A changes.
In column K1:K7 show the amount paid.
I have tried a vast amount of of different ideas from various people but the main problem I run up against is a am not able to get column A and column E to check each other to see if they are the same, if so continue on with G,I &K
The idea is when I open my excel sheet it will automatically check dates and complete the task.
All done with vba.
Thank in advance.

Excel 2013 64bit

 

[mole999]

dates are integer so as long as =ISNUMBER() returns true for both then you can check A=B as a number and should equal Zero