Date Format.... How Do I?

[rdjohnso]

I have a report where I am trying to make the headers Jan - Dec of Current Year.. so the first coloumn header should show: January 06... but the '06'
needs to be dynamic in the se3nse that next year it should show 07.

Anyone have an idea how I can do this in a single cell?

Thanks in advance for any help.

 

[EBGreen]

=RIGHT(YEAR(NOW()), 2)

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]