Turn a Calendar week number into dates
How can I display a date based on a calendar week?
My internal customer doesn't want to see a number (calendar week), he wants to see the data in week buckets but in dates.
Instead of seeing Week 35 (calendar week) he wants to see = 08.24.2015 to 08.30.2015
My query filter is based on relative week (from -1 to -6). so anytime the data in the report is pulled it will display last 6 weeks info.
Try following formula
=min([GI Actual Date] in ([Calendar week];[Gl Actual Date])) in ([Calendar Week])