Data validation with conditions

Hi

I am thinking of setting a cell with data validation by a list - Jan 2009 to Dec 2013. However, i would like to have the cell only to be shown current year options. ie although i have a list from jan 2009 to dec 2013, but only Jan 2010 to Dec 2010 will be shown as options in year 2010. when new year 2011 comes, it will automatically change the option from Jan 2011 to Dec 2011.

Is it possible? If so, how to achieve it?

thanks

For sake of demo... assume your month listing is in named range _DVmonths (60 months from 1-Jan-2009 to 31-Dec-2013)

DV configuration:

Please Login or Register  to view this content.

given use of TODAY the DV is a volatile construct and thus I opted to use OFFSET for sake of simplicity