need to calculate interest rate using months not years

Originally Posted by Special-K

Simple Interest formula

=P(1+rt)
where P is money invested
r is interest rate as percentage
t is time periods

With money invested in A1
result in B1
and time period in D1

rate of interest would be

=(B1/A1-1)/D1

Thank you. I appreciate you taking time to help.

yeto