precentage rate formula
 

Here's what I need to accomplish:

I have a dollar amount (column A) and a date (column B) in two separate
columns, I need to create a formula that will calculate 8% of the amount on a
per year basis starting from the date listed in column B to todays date.

thanks in advance.
roger

precentage rate formula
 

Not really sure how you want the % shown, would it be calculate for the year
and then broken down by the days of the year? Probably needs a bit more
explanation on your part but I experimented with this.

Col A your $ total
Col B the date you enter
Col C try this formula =A1*0.08*(TODAY()-B1)/365

A1 is multiplied by .08 to get the $ amount for one year. Today takes
todays date and subtracts the date you have entered, it then divides it by
365.



"Roger" wrote:

Here's what I need to accomplish:

I have a dollar amount (column A) and a date (column B) in two separate
columns, I need to create a formula that will calculate 8% of the amount on a
per year basis starting from the date listed in column B to todays date.

thanks in advance.
roger

precentage rate formula
 

that did the trick, thanks Tim!

"tim m" wrote:

Not really sure how you want the % shown, would it be calculate for the year
and then broken down by the days of the year? Probably needs a bit more
explanation on your part but I experimented with this.

Col A your $ total
Col B the date you enter
Col C try this formula =A1*0.08*(TODAY()-B1)/365

A1 is multiplied by .08 to get the $ amount for one year. Today takes
todays date and subtracts the date you have entered, it then divides it by
365.



"Roger" wrote:

Here's what I need to accomplish:

I have a dollar amount (column A) and a date (column B) in two separate
columns, I need to create a formula that will calculate 8% of the amount on a
per year basis starting from the date listed in column B to todays date.

thanks in advance.
roger