Geek Alert: How to get Week Ending in SSRS

I was having some issues trying to find the friday date on a report in SSRS (Sql Server Reporting Services). A bunch of our reports needed to be labeled with the following friday of the day it was run. Here’s how I got it.

=”Week Ending: ” + dateadd(“D”,6-Weekday(today()),today())

the “Week Ending:” is so it would look like
Week Ending: 09/05/09