Rolling months based on date

[Rob (SA)]

Hi Folks,

My challenge is the following:

I would like the spreadsheet values in F8 to F19 to change based on the date I place in cell B2.

So if I select January 2014 for example then the value in B19 changes to the previous month ( December 2013) and the value would be that in calculated in AP3 would appear in F19

and if I select February 2014 then the value of AP3 would be place in the cell F18.

I think there might be simpler way of doing things and look forward to your inputs