12 rolling months dynamically

[#1]

Hello Friends,

I would like to create a control, that should manage 12 rolling months.

I have a data of 2009,2010,2011,2012, now we are in July, by default it should display the July 2012 in reverse of 12 months and a arrow button should move one month forward and one arrow button for backward.

Can any one tell me how to achieve it, any working example will be appreciable.

Regards

Chriss

[#2]

Hello Chriss

You can use this function to achieve what you need:

=AddMonths(today(),-12) --->This will return 7/19/2011

You can also use a variable instead of today and with that you can create the rolling 12 month view
Hope this helps

Pablo