Help with formula

[rkrs]

Hi

please find attached sample sheet with my comments below on what i try to achieve. Hope am clear in explaining.

I have already tried a formula in column c, which is not giving me the desired result as i am trying to do it in one formula itself

if its success then i could make yearly plan

any help is much appreciated.

Thanks in anticipation

rkrs