Continuing Calculation with Dates

[hpatel517]

Hello All,

I posted some time ago to some help on developing a calculation that updates with the date. I have attached what I came up with and it was working great. I didn't take into account the change of the year.

The story behind this is, we are accounting for 3% inflation beginning March of every year. It gets applied by taking 3% x the number of months until March. Since 2016, January should be 11th month, but my calculation is set up so that it is the 1st Month.

How can I update this to take the year into account?

Thank you!

-H.Patel

[CAntosh]

Would putting something like the following in B6 fix your problem?

=IF($D$2>=3,0.03*((D2-2)/D2),0.03*(($D$2+10)/12))