I keep running into problems and need this forum! I'm wanting to show Jan of the current year. This needs to be automatically updated each year as it controls a calendar. For example, A1 will be Jan. 2010 and then will change to Jan 2011 when the year changes. I'm using a drop-down validation function now to change the years but I's like to have this update annually.

Thanks again for all the help,

K