Triggers on sheet properties: select current month and 6 previous months too

[terezagr]

Hi all,

does anyone know how to set a trigger on open sheet to select current month and 6 previous months too?

Cheers,

T.

[alexandros17]

I manage months in format 201401 as january 2014 and so on, in this case it is easy:

MyMonthField >= Year(AddMonths(Today(),-6))*100 + Month(AddMonths(Today(),-6)) and MyMonthField <= Year(Today())*100 + Month(Today())

Hope it helps

[terezagr]

Thank you! Have to slightly modified that for my case, but otherwise works well!