hw to give excel formula in excel sheet
for example if i want to calcutale interest for the following
from | to | Amt | rate of interest | total Interest for days |
January 4, 2009 | June 30, 2009 | 100,000.00 | 8% P A |
what formula i should set so that i can get the figure of total interest ( i dont want to count total days manully it shold be come in the formula also )