Formula to Calculate Compounded Percentage Per Year
Problem
Can anyone provide me with a formula to calculate 6% per year on an amount
of currency (14,000), for a period determine between two dates inclusive.
My Thoughts
Determine the number of days using the formula:
Start date 4/7/2005 End date 4/7/2007
=DATEDIF(A2,B2+1,"d") = 798 days
Then work out the 6% annual amount for every 366 days and remaining 66 days.
Not sure how to do this though...and I think I am overcomplicating the
calculation
Thanks in advance
|