Skip to Content
0
Former Member
Feb 24, 2009 at 05:45 PM

Convert Week Number of Year to Month

352 Views

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