I need a formula in my excel sheet that increases in value by 2.16 every month.
e.g. if cell A2 is "5" in January it must automaticly be "7.16" the first of February and "9.32" the first of March and so on.
Is there any formula to make this happen?
If a parameter to get yesterdays month existed...