precentage rate formula

R

Roger

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
 
T

tim m

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.
 
R

Roger

that did the trick, thanks Tim!

tim m said:
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.
Click to expand...
 
Top