Re: Get Start Date of a Week Number

I love these kinds of problems. :) Questions for you: You speak of already grouping the sales by week.
What method are you using for that, because that would probably point to a similar way to get the date for the week.
Are you are needing 52 columns for each report?
Is column 1 always the first week of the year?

On 11/26/2014 2:31 PM, Brian wrote:

Thank you for the feedback. In the forecast I am getting arbitrary dates
and quantities. The person getting the report simply wanted the quantities
accumulated by week. So, if I got data for Monday and Tuesday of the same
week, I would add those together.

In my report, I had a row for each item and then a column for each week.
It might look like this:

Item, Week 1, Week 2
ABC,344,200

And so on.

After generating that output, the user then asked to have the start date
for the week show instead of the week number so now it night look like:

Item, 2014-12-29, 2015-01-05
ABC,344,200

The 12/29 and 01/15 dates were just from a calendar I was looking at. I do
not think it matters at all if the definition of the week is the ISO one or
not. The main thing is that I am consistent and put dates as the column
headings and not week numbers anymore.

I think Birgitta's solution will work, but I am not in a place to try it
out at the moment.

If you've got other thoughts though, just let me know.

Thanks to all who replied so far!