formula in excel


(Guest)

i want to know a formula in excel

period


30 march 2009   to    30 april 2009         rate of int 8% pa amount 100000.00 

calculate the interest of the above period

formula like this

= 100000.00*0.08/365* here i want to add days that  i dont want to calculate manually  that should be come in the formula