Week Range Display In One Column

Summary

In OBI, how can I display a week date range (ex: 12/28/14 - 1/3/15) in one column

Content

I'd like to show a week date range (ex: 12/28/14-1/3/15) in one column (great for pivots and charts). I've focused my attempts using WEEK_OF_YEAR but I'm not having any luck (I'd rate my SQL skills at 3 on a scale of 1-10)

 

I've searched around but all I can find are examples of the First Day of the Month (which is great but not what I need). Any help would be greatly appreciated.

 

Using OBI with Taleo.

 

Thank you for your help.