Monthly increase

[Elmo9]

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 I could use =IF(MONTH(TODAY())>MONTH(YESTERDAY()),A2+2.16,A2 to do so but the MONTH(YESTERDAY()) does not exist to my knowledge...
Any help is welcome

 

[gaz_chops]

Not sure if I understand correctly, is it something like -

If so, try

=IF(B1=(EOMONTH(A1,0)+1),A2+2.16,A2)

In Cell B2 (2nd 5 in my example)

 

[Elmo9]

@gaz_chops Not quite.
This solution requires that I have a cell for each month. I want the same cell to increase by 2.16 each month.
I am making a calender that tracks vacation days and as a new rule takes place in DK by May where each employee recieves 2.16 vaacation days each month I would like the excel sheet to automaticly add this to the total vacation days. I then have a complete calender where each held day will be typed in and automatically subtracted from the total days count.

 

[gaz_chops]

You will need VB to do this in the same cell.

 

[Elmo9]

You will need VB to do this in the same cell.

VB?
I'm a newbie to this

 

[gaz_chops]

Visual Basic code, someone else will have to help as it's not my field.

 

[gaz_chops]

Give it a while, if no response bump this thread, don't start a new one.

 

[Elmo9]

Give it a while, if no response bump this thread, don't start a new one.

Thanks. I'll wait. At least I have until May
Otherwise I will do it as you have suggested as the calender will have cells with all the dates anyway. However this will require quite many IF()'s but it's doable at least.

 

[Elmo9]

Give it a while, if no response bump this thread, don't start a new one.

I found a solution myself: =IF(MONTH(NOW())>1,MONTH(NOW())*2.16+A1-2.16,A1)
This fomula will, if we have January, simply take my value in A1, if we have February it will take my A1 and add 2.16 (2*2.16-2.16) if we have March it will take A1 and add 4.32 (3*2.16-2.16) and so on.
Rather simple once I thought it through now that I had to update the calendar for 2022...

 

[bebo021999]

Shorter solution:

=A1+2.16*(MONTH(TODAY())-1)