+1 to +3 year average, and -2 to -4 year average

[kt_uwa1990]

you raise a good point Ksharp, I overlooked this issue. How do i remove the non-consecutive years?

[Ksharp]

Yes. My code will still be worked. Just make sure the INTNX() has the right form .

intnx('year',date,1,'s');   not intnx('year',1,date,'s');