title: How to get week ending date of a given date returned from a DateAdd expression
body: <p>Not sure how to take my current expression and get the week ending date of the week.</p>
  
  <p>My current expression returns the date, one week from today.</p>
  
  <pre><code>DateAdd(DateInterval.WeekOfYear, 1, today())
  </code></pre>
  
  <p>What I want to do instead is return the end date (Saturday) of that week instead.</p>
  
  <p>What do I need to add to this expression to get the desired result?</p>
  
  <p>Thanks!</p>
  
  <p>Okay, looks like I've got it but it's ugly. Can anyone help me streamline this?</p>
  
  <p>Here's what I have, based on turning Raj's example into an expression:</p>
  
  <p>="One Week Projected Backlog w/e "&amp; DateAdd(DateInterval.Day, 
    -1 * DatePart(DateInterval.WeekDay, 
    (DateAdd(DateInterval.WeekOfYear, 1, today()))) + 7, 
    (DateAdd(DateInterval.WeekOfYear, 1, today())))</p>