Always show Jan of current year
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
|