I need to format the week of the year as 200617 (YYYYWW). Any Ideas?
I tried using the custom format under Format but it dispays as 2006ww.
Is there a way to format as 200617 (Year 2006 & Week 17)?