Re: Get Start Date of a Week Number

[Booth Martin <booth@xxxxxxxxxxxx>]

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!