excel formula


(Guest)

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  )