Visual basic formula based on Date

[Utah7]

I need help with the visual basic code to calculate interest based on a date. If the date is before 01/27/2015 I need the formula to be Amt*.12/365*days. If it is on or after 01/27/2015, I need it to be Amt*.10/365*days.

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]Amt[/TD]
[TD]Days[/TD]
[TD]Interest[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01/25/2015[/TD]
[TD]500.00[/TD]
[TD]7[/TD]
[TD]Amt * .12/365*Days
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01/26/2015[/TD]
[TD]100.00[/TD]
[TD]6[/TD]
[TD]Amt * .12/365*Days[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01/27/2015[/TD]
[TD]125.00[/TD]
[TD]4[/TD]
[TD]Amt * .10/365*Days[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01/28/2015[/TD]
[TD]150.00[/TD]
[TD]3[/TD]
[TD]Amt * .10/365*Days[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I have tried using the If ELSE VB conditional statement but can't get it to work. There is actually 100's of dates and calculations in my file.
Thank you for your help.

 

[ndsutherland]

Are you sure you need VBA code? The following formula would return the desired result in column D
=B2*if(A2<42031,.12,.10)/365*C2
42031 is the number format of 1/27/2015 (number of days after 1/1/1900)