Trend damping
 

I am trying to work out a trend accross 24 months but applying most
emphasis/weighting to the most recent 6 months. I'm sure that there must be a
formula in excel that allows me to do this.
Thanks