Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
does anyone know how to set a trigger on open sheet to select current month and 6 previous months too?
Cheers,
T.
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
Thank you! Have to slightly modified that for my case, but otherwise works well!