to calculate this month, this year, last year figure

Hi

I have a report to contain data from 2009 to 2012. I need to calculate "this month actual", "Total for this year" and "Total for last year" in Coumn BD, BE & BF each.

Since there are more than two years data there, i would like to come up with a formula that it will update by itself (ie when 2011 comes, the formula will automatically link to 2011 data). Is it possible? if so, could someone please provide a solution?

Thanks