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.
<tbody>
</tbody>
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.
A | B | C | D | |
Date | Amt | Days | Interest | |
01/25/2015 | 500.00 | 7 | Amt * .12/365*Days | |
01/26/2015 | 100.00 | 6 | Amt * .12/365*Days | |
01/27/2015 | 125.00 | 4 | Amt * .10/365*Days | |
01/28/2015 | 150.00 | 3 | Amt * .10/365*Days |
<tbody>
</tbody>
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.