weeknum question

[dhx10000]

I'm using the weeknum function to calculate the weeknumber based on a cell that contains a modified date of my records. The problem I have is that I am using a pivot table to chart this data and it plots the weeknum as a number on the x axis. I would like to somehow transform this number into the date that it represents, then use it in a pivot table. Any idea how to do something like this?

Another problem I have is that we are nearing the end of the year and I don't know what to do once the new year hits and the weeknum becomes 1 again at the beginning of the year. Graphing data by week is a high priority here which is why I had to identify and use the weeknum.

thank you

 

[Tazguy37]

Another problem I have is that we are nearing the end of the year and I don't know what to do once the new year hits and the weeknum becomes 1 again at the beginning of the year. Graphing data by week is a high priority here which is why I had to identify and use the weeknum.

thank you

You can't make the graph go from week 52 (or 53) to 1?

 

[dhx10000]

Yes, but I'm just confused about how my chart will know to graph that new week number 1 from the previous week number one. So Jan 1, 2005 vs. Jan 1, 2006