so I am trying to create an annual schedule where a fee is increase by a percentage on its anniversary date.
ROUND($A$8*((1+$A$9)^(YEAR(B14)-YEAR($A$6))),2)
This formula is giving me the initial correct balance, but it does not increase on the anniversary month in my 12 rows J-D. I have tried changing the "Year" formula to a "date" one with no success. Help!
Bookmarks