Does anyone know of a formula that would work in Crystal XI to return the "Month of the Year" for a "Week Number of Year" input?
In my example I have columns 1-53 for the weeks of 2009. I would like to sub categorize these columns by the month of the year. Weeks 1-5 would be January, weeks 6-9 would be February, etc.
I've found help on converting a date to the "Week Number of Year" but not the inverse.
Thanks for any suggestions!
David