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