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
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