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